Pandas Profiling Report

Dataset statistics

Number of variables	114
Number of observations	990
Missing cells	35191
Missing cells (%)	31.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	705.9 KiB
Average record size in memory	730.1 B

Variable types

UNSUPPORTED	36
CAT	36
BOOL	32
NUM	9
PATH	1

Warnings

`subreddit` has constant value "990"	Constant
`saved` has constant value "990"	Constant
`clicked` has constant value "990"	Constant
`subreddit_name_prefixed` has constant value "990"	Constant
`hidden` has constant value "990"	Constant
`pwls` has constant value "990"	Constant
`downs` has constant value "990"	Constant
`hide_score` has constant value "990"	Constant
`quarantine` has constant value "990"	Constant
`subreddit_type` has constant value "990"	Constant
`is_original_content` has constant value "990"	Constant
`is_meta` has constant value "990"	Constant
`can_mod_post` has constant value "990"	Constant
`archived` has constant value "990"	Constant
`is_crosspostable` has constant value "990"	Constant
`pinned` has constant value "990"	Constant
`media_only` has constant value "990"	Constant
`can_gild` has constant value "990"	Constant
`spoiler` has constant value "990"	Constant
`locked` has constant value "990"	Constant
`visited` has constant value "990"	Constant
`subreddit_id` has constant value "990"	Constant
`is_robot_indexable` has constant value "990"	Constant
`contest_mode` has constant value "990"	Constant
`parent_whitelist_status` has constant value "990"	Constant
`selftext` has a high cardinality: 58 distinct values	High cardinality
`author_fullname` has a high cardinality: 525 distinct values	High cardinality
`thumbnail` has a high cardinality: 881 distinct values	High cardinality
`domain` has a high cardinality: 148 distinct values	High cardinality
`selftext_html` has a high cardinality: 57 distinct values	High cardinality
`url_overridden_by_dest` has a high cardinality: 916 distinct values	High cardinality
`author` has a high cardinality: 526 distinct values	High cardinality
`url` has a high cardinality: 986 distinct values	High cardinality
`score` is highly correlated with `ups`	High correlation
`ups` is highly correlated with `score`	High correlation
`over_18` is highly correlated with `wls`	High correlation
`wls` is highly correlated with `over_18`	High correlation
`subreddit_subscribers` is highly correlated with `created` and 1 other fields	High correlation
`created` is highly correlated with `subreddit_subscribers` and 1 other fields	High correlation
`created_utc` is highly correlated with `created` and 1 other fields	High correlation
`approved_at_utc` has 990 (100.0%) missing values	Missing
`mod_reason_title` has 990 (100.0%) missing values	Missing
`link_flair_css_class` has 452 (45.7%) missing values	Missing
`thumbnail_height` has 96 (9.7%) missing values	Missing
`top_awarded_type` has 990 (100.0%) missing values	Missing
`author_flair_background_color` has 980 (99.0%) missing values	Missing
`thumbnail_width` has 96 (9.7%) missing values	Missing
`author_flair_template_id` has 990 (100.0%) missing values	Missing
`secure_media` has 883 (89.2%) missing values	Missing
`category` has 990 (100.0%) missing values	Missing
`link_flair_text` has 449 (45.4%) missing values	Missing
`approved_by` has 990 (100.0%) missing values	Missing
`author_flair_css_class` has 984 (99.4%) missing values	Missing
`post_hint` has 97 (9.8%) missing values	Missing
`content_categories` has 990 (100.0%) missing values	Missing
`mod_note` has 990 (100.0%) missing values	Missing
`crosspost_parent_list` has 977 (98.7%) missing values	Missing
`removed_by_category` has 990 (100.0%) missing values	Missing
`banned_by` has 990 (100.0%) missing values	Missing
`selftext_html` has 933 (94.2%) missing values	Missing
`likes` has 990 (100.0%) missing values	Missing
`suggested_sort` has 986 (99.6%) missing values	Missing
`banned_at_utc` has 990 (100.0%) missing values	Missing
`url_overridden_by_dest` has 70 (7.1%) missing values	Missing
`view_count` has 990 (100.0%) missing values	Missing
`preview` has 97 (9.8%) missing values	Missing
`link_flair_template_id` has 510 (51.5%) missing values	Missing
`author_flair_text` has 984 (99.4%) missing values	Missing
`removed_by` has 990 (100.0%) missing values	Missing
`num_reports` has 990 (100.0%) missing values	Missing
`distinguished` has 988 (99.8%) missing values	Missing
`mod_reason_by` has 990 (100.0%) missing values	Missing
`removal_reason` has 990 (100.0%) missing values	Missing
`report_reasons` has 990 (100.0%) missing values	Missing
`discussion_type` has 990 (100.0%) missing values	Missing
`crosspost_parent` has 977 (98.7%) missing values	Missing
`author_flair_text_color` has 980 (99.0%) missing values	Missing
`media` has 883 (89.2%) missing values	Missing
`author_cakeday` has 988 (99.8%) missing values	Missing
`is_gallery` has 984 (99.4%) missing values	Missing
`media_metadata` has 983 (99.3%) missing values	Missing
`gallery_data` has 984 (99.4%) missing values	Missing
`selftext_html` is uniformly distributed	Uniform
`url_overridden_by_dest` is uniformly distributed	Uniform
`crosspost_parent` is uniformly distributed	Uniform
`url` is uniformly distributed	Uniform
`title` has unique values	Unique
`name` has unique values	Unique
`created` has unique values	Unique
`id` has unique values	Unique
`permalink` has unique values	Unique
`created_utc` has unique values	Unique
`approved_at_utc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mod_reason_title` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`link_flair_richtext` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`top_awarded_type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`media_embed` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`author_flair_template_id` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`user_reports` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`secure_media` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`category` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`secure_media_embed` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`approved_by` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`edited` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`author_flair_richtext` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`gildings` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`content_categories` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mod_note` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`crosspost_parent_list` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`removed_by_category` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`banned_by` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`likes` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`banned_at_utc` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`view_count` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`preview` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`all_awardings` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`awarders` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`treatment_tags` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`removed_by` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`num_reports` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mod_reason_by` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`removal_reason` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`report_reasons` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`discussion_type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`mod_reports` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`media` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`media_metadata` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`gallery_data` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`ups` has 13 (1.3%) zeros	Zeros
`total_awards_received` has 936 (94.5%) zeros	Zeros
`score` has 13 (1.3%) zeros	Zeros
`num_comments` has 242 (24.4%) zeros	Zeros
`num_crossposts` has 943 (95.3%) zeros	Zeros

Reproduction

Analysis started	2021-01-12 13:07:10.526527
Analysis finished	2021-01-12 13:07:39.292140
Duration	28.77 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

approved_at_utc
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

subreddit
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

democrats	990

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	8910
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	democrats
2nd row	democrats
3rd row	democrats
4th row	democrats
5th row	democrats

Value	Count	Frequency (%)
democrats	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
democrats	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
d	990	11.1%
e	990	11.1%
m	990	11.1%
o	990	11.1%
c	990	11.1%
r	990	11.1%
a	990	11.1%
t	990	11.1%
s	990	11.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8910	100.0%

Most frequent character per category

Value	Count	Frequency (%)
d	990	11.1%
e	990	11.1%
m	990	11.1%
o	990	11.1%
c	990	11.1%
r	990	11.1%
a	990	11.1%
t	990	11.1%
s	990	11.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8910	100.0%

Most frequent character per script

Value	Count	Frequency (%)
d	990	11.1%
e	990	11.1%
m	990	11.1%
o	990	11.1%
c	990	11.1%
r	990	11.1%
a	990	11.1%
t	990	11.1%
s	990	11.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8910	100.0%

Most frequent character per block

Value	Count	Frequency (%)
d	990	11.1%
e	990	11.1%
m	990	11.1%
o	990	11.1%
c	990	11.1%
r	990	11.1%
a	990	11.1%
t	990	11.1%
s	990	11.1%

selftext
Categorical

HIGH CARDINALITY

Distinct	58
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

	933
[https://www.politicususa.com/2021/01/05/warnock-beats-loeffler.html](https://www.politicususa.com/2021/01/05/warnock-beats-loeffler.html)	1
I heard one of the hosts whisper under his breath about the Georgia senator election demographic change and I heard “well there are less white people there now” which really worries me for the part of the country that is hard right. Are people seriously that biased and racist on the right?	1
I am a registered Democrat, which leans toward the center. I am known for picking candidates in the primaries that are not viable by the time they get to my State. At the end of the day, I end up supporting the nominee. I have also supported Democrats in races not in my state but that is rare. However, this changes today. The certification will go ahead overnight. If the republicans have any decency and care about the Country they will drop their objections, which are not going to do anything other than pander to these criminals that broke into the Capitol. But if they do not, I pledge that I will get the list of the representatives and Senators that vote for this disgrace and will pick a dozen and support their opponents. If you are a center democrat like myself, someone to the right or a progressive. This needs a response. If you do not have money to contribute then please pledge to support the candidate nearby or work a phone bank on 2022. If you live in a deep blue state then work for candidate phone banks in other states. I know a lot of people did since I got half a dozen calls from CA and MA as I live in Florida.	1
Given the turmoil in DC right now, will this affect whether or not Biden will be the next president or is what the Proud Boys disrupted simply ceremonial?	1
Other values (53)	53

Length

Max length	6821
Median length	0
Mean length	25.89191919
Min length	0

Characters and Unicode

Total characters	25633
Distinct characters	92
Distinct categories	14 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	5.8%

Sample

1st row
2nd row
3rd row
4th row
5th row

Value	Count	Frequency (%)
	933	94.2%
[https://www.politicususa.com/2021/01/05/warnock-beats-loeffler.html](https://www.politicususa.com/2021/01/05/warnock-beats-loeffler.html)	1	0.1%
I heard one of the hosts whisper under his breath about the Georgia senator election demographic change and I heard “well there are less white people there now” which really worries me for the part of the country that is hard right. Are people seriously that biased and racist on the right?	1	0.1%
I am a registered Democrat, which leans toward the center. I am known for picking candidates in the primaries that are not viable by the time they get to my State. At the end of the day, I end up supporting the nominee. I have also supported Democrats in races not in my state but that is rare. However, this changes today. The certification will go ahead overnight. If the republicans have any decency and care about the Country they will drop their objections, which are not going to do anything other than pander to these criminals that broke into the Capitol. But if they do not, I pledge that I will get the list of the representatives and Senators that vote for this disgrace and will pick a dozen and support their opponents. If you are a center democrat like myself, someone to the right or a progressive. This needs a response. If you do not have money to contribute then please pledge to support the candidate nearby or work a phone bank on 2022. If you live in a deep blue state then work for candidate phone banks in other states. I know a lot of people did since I got half a dozen calls from CA and MA as I live in Florida.	1	0.1%
Given the turmoil in DC right now, will this affect whether or not Biden will be the next president or is what the Proud Boys disrupted simply ceremonial?	1	0.1%
Without your(his) idiocy, the sleeping democrats who have not voted much in the past may not have woken to vote this time.	1	0.1%
and that’s universal healthcare, a living wage, universal childcare, more access to higher education, and a progressive tax rate. Because that’s what you fucking deserve.	1	0.1%
She deserves it for her work in Georgia this past election cycle. Her efforts in registering new voters and shedding light on voter suppression in Georgia had a large part in flipping Georgia. And she definitely deserves it more than Limbaugh	1	0.1%
All this talk about voter fraud in Georgia isa formof voter Intimidation. The President just called out Fulton County, where Atlanta is, which is a glaring dog whistle.	1	0.1%
Nvm, it's just privated	1	0.1%
Other values (48)	48	4.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
the	226	5.1%
to	128	2.9%
of	105	2.4%
a	103	2.3%
and	102	2.3%
i	86	1.9%
in	77	1.7%
that	60	1.4%
is	49	1.1%
it	49	1.1%
Other values (1402)	3455	77.8%

Most occurring characters

Value	Count	Frequency (%)
	4334	16.9%
e	2445	9.5%
t	1831	7.1%
a	1532	6.0%
o	1520	5.9%
n	1367	5.3%
i	1357	5.3%
s	1182	4.6%
r	1128	4.4%
h	1003	3.9%
Other values (82)	7934	31.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19386	75.6%
Space Separator	4334	16.9%
Uppercase Letter	788	3.1%
Other Punctuation	685	2.7%
Decimal Number	215	0.8%
Control	128	0.5%
Dash Punctuation	34	0.1%
Final Punctuation	19	0.1%
Open Punctuation	17	0.1%
Close Punctuation	17	0.1%
Other values (4)	10	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	2445	12.6%
t	1831	9.4%
a	1532	7.9%
o	1520	7.8%
n	1367	7.1%
i	1357	7.0%
s	1182	6.1%
r	1128	5.8%
h	1003	5.2%
l	810	4.2%
Other values (16)	5211	26.9%

Value	Count	Frequency (%)
I	144	18.3%
T	81	10.3%
A	62	7.9%
R	56	7.1%
S	41	5.2%
M	41	5.2%
W	41	5.2%
B	40	5.1%
C	38	4.8%
H	32	4.1%
Other values (15)	212	26.9%

Value	Count	Frequency (%)
.	259	37.8%
,	178	26.0%
'	86	12.6%
/	42	6.1%
?	29	4.2%
"	26	3.8%
:	16	2.3%
*	13	1.9%
!	9	1.3%
;	9	1.3%
Other values (6)	18	2.6%

Value	Count	Frequency (%)
2	49	22.8%
0	44	20.5%
1	36	16.7%
5	17	7.9%
8	15	7.0%
3	13	6.0%
6	13	6.0%
7	11	5.1%
9	11	5.1%
4	6	2.8%

Value	Count	Frequency (%)
’	18	94.7%
”	1	5.3%

Value	Count	Frequency (%)
-	33	97.1%
–	1	2.9%

Value	Count	Frequency (%)
(	13	76.5%
[	4	23.5%

Value	Count	Frequency (%)
)	13	76.5%
]	4	23.5%

Value	Count	Frequency (%)
“	1	50.0%
‘	1	50.0%

Value	Count	Frequency (%)
	4334	100.0%

Value	Count	Frequency (%)
	128	100.0%

Value	Count	Frequency (%)
$	3	100.0%

Value	Count	Frequency (%)
=	4	100.0%

Value	Count	Frequency (%)
🌊	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20174	78.7%
Common	5459	21.3%

Most frequent character per script

Value	Count	Frequency (%)
e	2445	12.1%
t	1831	9.1%
a	1532	7.6%
o	1520	7.5%
n	1367	6.8%
i	1357	6.7%
s	1182	5.9%
r	1128	5.6%
h	1003	5.0%
l	810	4.0%
Other values (41)	5999	29.7%

Value	Count	Frequency (%)
	4334	79.4%
.	259	4.7%
,	178	3.3%
	128	2.3%
'	86	1.6%
2	49	0.9%
0	44	0.8%
/	42	0.8%
1	36	0.7%
-	33	0.6%
Other values (31)	270	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25605	99.9%
Punctuation	23	0.1%
None	5	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	4334	16.9%
e	2445	9.5%
t	1831	7.2%
a	1532	6.0%
o	1520	5.9%
n	1367	5.3%
i	1357	5.3%
s	1182	4.6%
r	1128	4.4%
h	1003	3.9%
Other values (74)	7906	30.9%

Value	Count	Frequency (%)
’	18	78.3%
–	1	4.3%
“	1	4.3%
”	1	4.3%
…	1	4.3%
‘	1	4.3%

Value	Count	Frequency (%)
§	4	80.0%
🌊	1	20.0%

author_fullname
Categorical

HIGH CARDINALITY

Distinct	525
Distinct (%)	53.2%
Missing	4
Missing (%)	0.4%
Memory size	7.7 KiB

t2_8xm96m07	53
t2_yfff4	48
t2_612zd	27
t2_nkk56	21
t2_1vzd9pjy	15
Other values (520)	822

Length

Max length	11
Median length	11
Mean length	9.796969697
Min length	3

Characters and Unicode

Total characters	9699
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	401 ?
Unique (%)	40.7%

Sample

1st row	t2_nkk56
2nd row	t2_4f8e5viq
3rd row	t2_17c1os
4th row	t2_yfff4
5th row	t2_2tm5mq8b

Value	Count	Frequency (%)
t2_8xm96m07	53	5.4%
t2_yfff4	48	4.8%
t2_612zd	27	2.7%
t2_nkk56	21	2.1%
t2_1vzd9pjy	15	1.5%
t2_97a3	15	1.5%
t2_yj1q2	15	1.5%
t2_6n9zacfv	14	1.4%
t2_442hlze5	14	1.4%
t2_7vedo	14	1.4%
Other values (515)	750	75.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
t2_8xm96m07	53	5.4%
t2_yfff4	48	4.8%
t2_612zd	27	2.7%
t2_nkk56	21	2.1%
t2_97a3	15	1.5%
t2_yj1q2	15	1.5%
t2_1vzd9pjy	15	1.5%
t2_7vedo	14	1.4%
t2_442hlze5	14	1.4%
t2_6n9zacfv	14	1.4%
Other values (516)	754	76.2%

Most occurring characters

Value	Count	Frequency (%)
2	1235	12.7%
t	1113	11.5%
_	986	10.2%
1	355	3.7%
6	311	3.2%
5	282	2.9%
7	277	2.9%
f	273	2.8%
4	257	2.6%
9	245	2.5%
Other values (27)	4365	45.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5153	53.1%
Decimal Number	3560	36.7%
Connector Punctuation	986	10.2%

Most frequent character per category

Value	Count	Frequency (%)
t	1113	21.6%
f	273	5.3%
m	210	4.1%
z	209	4.1%
y	204	4.0%
k	185	3.6%
v	179	3.5%
j	175	3.4%
a	170	3.3%
d	168	3.3%
Other values (16)	2267	44.0%

Value	Count	Frequency (%)
2	1235	34.7%
1	355	10.0%
6	311	8.7%
5	282	7.9%
7	277	7.8%
4	257	7.2%
9	245	6.9%
8	238	6.7%
3	199	5.6%
0	161	4.5%

Value	Count	Frequency (%)
_	986	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5153	53.1%
Common	4546	46.9%

Most frequent character per script

Value	Count	Frequency (%)
t	1113	21.6%
f	273	5.3%
m	210	4.1%
z	209	4.1%
y	204	4.0%
k	185	3.6%
v	179	3.5%
j	175	3.4%
a	170	3.3%
d	168	3.3%
Other values (16)	2267	44.0%

Value	Count	Frequency (%)
2	1235	27.2%
_	986	21.7%
1	355	7.8%
6	311	6.8%
5	282	6.2%
7	277	6.1%
4	257	5.7%
9	245	5.4%
8	238	5.2%
3	199	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9699	100.0%

Most frequent character per block

Value	Count	Frequency (%)
2	1235	12.7%
t	1113	11.5%
_	986	10.2%
1	355	3.7%
6	311	3.2%
5	282	2.9%
7	277	2.9%
f	273	2.8%
4	257	2.6%
9	245	2.5%
Other values (27)	4365	45.0%

saved
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

mod_reason_title
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

gilded
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

0	984
1	6

Common Values
Chart

Value	Count	Frequency (%)
0	984	99.4%
1	6	0.6%

clicked
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

title
Categorical

UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

Donald J. Trump on Twitter--Anarchists, Agitators or Protestors who vandalize or damage our Federal Courthouse in Portland, or any Federal Buildings in any of our Cities or States, will be prosecuted under our recently re-enacted Statues & Monuments Act. MINIMUM TEN YEARS IN PRISON. Don’t do it!	1
West Virginia lawmaker who recorded himself storming Capitol urged to resign in petition	1
Thank you President Thrump for making this possible.	1
Uh oh	1
Can’t believe we made it through 2020 just to face trump zombie apocalypse smh	1
Other values (985)	985

Length

Max length	300
Median length	58.5
Mean length	70.09393939
Min length	1

Characters and Unicode

Total characters	69393
Distinct characters	125
Distinct categories	18 ?
Distinct scripts	4 ?
Distinct blocks	8 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	990 ?
Unique (%)	100.0%

Sample

1st row	House Democrats launch second impeachment of Trump for his role in last week's deadly Capitol attack
2nd row	Do I have to?
3rd row	"Camp Auschwitz" guy identified!
4th row	No Crawling Back!!!
5th row	Use the 14th Amendment to ban Trump

Value	Count	Frequency (%)
Donald J. Trump on Twitter--Anarchists, Agitators or Protestors who vandalize or damage our Federal Courthouse in Portland, or any Federal Buildings in any of our Cities or States, will be prosecuted under our recently re-enacted Statues & Monuments Act. MINIMUM TEN YEARS IN PRISON. Don’t do it!	1	0.1%
West Virginia lawmaker who recorded himself storming Capitol urged to resign in petition	1	0.1%
Thank you President Thrump for making this possible.	1	0.1%
Uh oh	1	0.1%
Can’t believe we made it through 2020 just to face trump zombie apocalypse smh	1	0.1%
And the winner is 👇👇	1	0.1%
Frustration over police response to Capitol rioters vs. BLM protesters.	1	0.1%
Latest on Capitol Hill: Explosive device found, mob roams building	1	0.1%
Georgia On My Mind	1	0.1%
We said we needed a revolution	1	0.1%
Other values (980)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
the	441	3.8%
to	326	2.8%
of	217	1.9%
trump	210	1.8%
a	183	1.6%
and	169	1.5%
in	152	1.3%
is	129	1.1%
for	127	1.1%
capitol	126	1.1%
Other values (3220)	9504	82.0%

Most occurring characters

Value	Count	Frequency (%)
	10594	15.3%
e	6182	8.9%
t	4517	6.5%
o	4369	6.3%
a	4009	5.8%
i	3744	5.4%
r	3542	5.1%
n	3518	5.1%
s	3465	5.0%
l	2192	3.2%
Other values (115)	23261	33.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51049	73.6%
Space Separator	10594	15.3%
Uppercase Letter	5070	7.3%
Other Punctuation	1789	2.6%
Decimal Number	382	0.6%
Final Punctuation	147	0.2%
Dash Punctuation	143	0.2%
Close Punctuation	49	0.1%
Open Punctuation	47	0.1%
Initial Punctuation	43	0.1%
Other values (8)	80	0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	6182	12.1%
t	4517	8.8%
o	4369	8.6%
a	4009	7.9%
i	3744	7.3%
r	3542	6.9%
n	3518	6.9%
s	3465	6.8%
l	2192	4.3%
h	1978	3.9%
Other values (17)	13533	26.5%

Value	Count	Frequency (%)
T	663	13.1%
C	415	8.2%
S	357	7.0%
A	351	6.9%
I	327	6.4%
P	264	5.2%
R	260	5.1%
D	225	4.4%
W	224	4.4%
O	217	4.3%
Other values (16)	1767	34.9%

Value	Count	Frequency (%)
😂	3	10.0%
♂	3	10.0%
👇	2	6.7%
🤷	2	6.7%
🙏	1	3.3%
🤮	1	3.3%
💔	1	3.3%
🩹	1	3.3%
🙅	1	3.3%
😭	1	3.3%
Other values (14)	14	46.7%

Value	Count	Frequency (%)
.	671	37.5%
,	270	15.1%
'	240	13.4%
!	177	9.9%
:	113	6.3%
?	100	5.6%
"	92	5.1%
/	47	2.6%
;	25	1.4%
*	14	0.8%
Other values (6)	40	2.2%

Value	Count	Frequency (%)
0	127	33.2%
1	74	19.4%
2	74	19.4%
5	29	7.6%
4	19	5.0%
9	18	4.7%
6	16	4.2%
7	11	2.9%
3	9	2.4%
8	5	1.3%

Value	Count	Frequency (%)
-	136	95.1%
—	5	3.5%
–	2	1.4%

Value	Count	Frequency (%)
\|	18	78.3%
+	4	17.4%
=	1	4.3%

Value	Count	Frequency (%)
‘	23	53.5%
“	20	46.5%

Value	Count	Frequency (%)
’	129	87.8%
”	18	12.2%

Value	Count	Frequency (%)
)	48	98.0%
]	1	2.0%

Value	Count	Frequency (%)
(	46	97.9%
[	1	2.1%

Value	Count	Frequency (%)
¯	2	66.7%
🏼	1	33.3%

Value	Count	Frequency (%)
	10594	100.0%

Value	Count	Frequency (%)
$	10	100.0%

Value	Count	Frequency (%)
‍	4	100.0%

Value	Count	Frequency (%)
️	4	100.0%

Value	Count	Frequency (%)
_	5	100.0%

Value	Count	Frequency (%)
ツ	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56119	80.9%
Common	13265	19.1%
Inherited	8	< 0.1%
Katakana	1	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
	10594	79.9%
.	671	5.1%
,	270	2.0%
'	240	1.8%
!	177	1.3%
-	136	1.0%
’	129	1.0%
0	127	1.0%
:	113	0.9%
?	100	0.8%
Other values (59)	708	5.3%

Value	Count	Frequency (%)
e	6182	11.0%
t	4517	8.0%
o	4369	7.8%
a	4009	7.1%
i	3744	6.7%
r	3542	6.3%
n	3518	6.3%
s	3465	6.2%
l	2192	3.9%
h	1978	3.5%
Other values (43)	18603	33.1%

Value	Count	Frequency (%)
‍	4	50.0%
️	4	50.0%

Value	Count	Frequency (%)
ツ	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	69142	99.6%
Punctuation	212	0.3%
None	19	< 0.1%
Emoticons	9	< 0.1%
Misc Symbols	4	< 0.1%
VS	4	< 0.1%
Enclosed Alphanum Sup	2	< 0.1%
Katakana	1	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	10594	15.3%
e	6182	8.9%
t	4517	6.5%
o	4369	6.3%
a	4009	5.8%
i	3744	5.4%
r	3542	5.1%
n	3518	5.1%
s	3465	5.0%
l	2192	3.2%
Other values (78)	23010	33.3%

Value	Count	Frequency (%)
’	129	60.8%
‘	23	10.8%
“	20	9.4%
”	18	8.5%
•	11	5.2%
—	5	2.4%
‍	4	1.9%
–	2	0.9%

Value	Count	Frequency (%)
😂	3	33.3%
🙏	1	11.1%
🙅	1	11.1%
😭	1	11.1%
😏	1	11.1%
😒	1	11.1%
🙄	1	11.1%

Value	Count	Frequency (%)
👇	2	10.5%
🤷	2	10.5%
¯	2	10.5%
ú	1	5.3%
🤮	1	5.3%
💔	1	5.3%
🩹	1	5.3%
🤣	1	5.3%
🤡	1	5.3%
🍑	1	5.3%
Other values (6)	6	31.6%

Value	Count	Frequency (%)
♂	3	75.0%
♀	1	25.0%

Value	Count	Frequency (%)
️	4	100.0%

Value	Count	Frequency (%)
ツ	1	100.0%

Value	Count	Frequency (%)
🇺	1	50.0%
🇸	1	50.0%

link_flair_richtext
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

subreddit_name_prefixed
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

r/democrats	990

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	10890
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	r/democrats
2nd row	r/democrats
3rd row	r/democrats
4th row	r/democrats
5th row	r/democrats

Value	Count	Frequency (%)
r/democrats	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
r/democrats	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
r	1980	18.2%
/	990	9.1%
d	990	9.1%
e	990	9.1%
m	990	9.1%
o	990	9.1%
c	990	9.1%
a	990	9.1%
t	990	9.1%
s	990	9.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9900	90.9%
Other Punctuation	990	9.1%

Most frequent character per category

Value	Count	Frequency (%)
r	1980	20.0%
d	990	10.0%
e	990	10.0%
m	990	10.0%
o	990	10.0%
c	990	10.0%
a	990	10.0%
t	990	10.0%
s	990	10.0%

Value	Count	Frequency (%)
/	990	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9900	90.9%
Common	990	9.1%

Most frequent character per script

Value	Count	Frequency (%)
r	1980	20.0%
d	990	10.0%
e	990	10.0%
m	990	10.0%
o	990	10.0%
c	990	10.0%
a	990	10.0%
t	990	10.0%
s	990	10.0%

Value	Count	Frequency (%)
/	990	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10890	100.0%

Most frequent character per block

Value	Count	Frequency (%)
r	1980	18.2%
/	990	9.1%
d	990	9.1%
e	990	9.1%
m	990	9.1%
o	990	9.1%
c	990	9.1%
a	990	9.1%
t	990	9.1%
s	990	9.1%

hidden
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

pwls
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

6	990

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	990
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6
2nd row	6
3rd row	6
4th row	6
5th row	6

Value	Count	Frequency (%)
6	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
6	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
6	990	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	990	100.0%

Most frequent character per category

Value	Count	Frequency (%)
6	990	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	990	100.0%

Most frequent character per script

Value	Count	Frequency (%)
6	990	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	990	100.0%

Most frequent character per block

Value	Count	Frequency (%)
6	990	100.0%

link_flair_css_class
Categorical

MISSING

Distinct	2
Distinct (%)	0.4%
Missing	452
Missing (%)	45.7%
Memory size	7.7 KiB

	480
blue	58

Length

Max length	4
Median length	3
Mean length	1.604040404
Min length	0

Characters and Unicode

Total characters	1588
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row
2nd row	nan
3rd row	nan
4th row
5th row

Value	Count	Frequency (%)
	480	48.5%
blue	58	5.9%
(Missing)	452	45.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	452	88.6%
blue	58	11.4%

Most occurring characters

Value	Count	Frequency (%)
n	904	56.9%
a	452	28.5%
b	58	3.7%
l	58	3.7%
u	58	3.7%
e	58	3.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1588	100.0%

Most frequent character per category

Value	Count	Frequency (%)
n	904	56.9%
a	452	28.5%
b	58	3.7%
l	58	3.7%
u	58	3.7%
e	58	3.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1588	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	904	56.9%
a	452	28.5%
b	58	3.7%
l	58	3.7%
u	58	3.7%
e	58	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1588	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	904	56.9%
a	452	28.5%
b	58	3.7%
l	58	3.7%
u	58	3.7%
e	58	3.7%

downs
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

0	990

Common Values
Chart

Value	Count	Frequency (%)
0	990	100.0%

thumbnail_height
Real number (ℝ_≥0)

MISSING

Distinct	80
Distinct (%)	8.9%
Missing	96
Missing (%)	9.7%
Infinite	0
Infinite (%)	0.0%

Mean	101.163311
Minimum	31
Maximum	140
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 KiB

Quantile statistics

Minimum	31
5-th percentile	72
Q1	78
median	93
Q3	139
95-th percentile	140
Maximum	140
Range	109
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	26.70183247
Coefficient of variation (CV)	0.2639477911
Kurtosis	-1.184027931
Mean	101.163311
Median Absolute Deviation (MAD)	15
Skewness	0.3632411842
Sum	90440
Variance	712.9878573
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
140	221	22.3%
78	179	18.1%
105	90	9.1%
93	89	9.0%
73	72	7.3%
70	11	1.1%
92	10	1.0%
72	10	1.0%
94	8	0.8%
79	7	0.7%
Other values (70)	197	19.9%
(Missing)	96	9.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
31	1	0.1%
35	1	0.1%
38	1	0.1%
39	1	0.1%
41	1	0.1%

Value	Count	Frequency (%)
140	221	22.3%
139	4	0.4%
138	2	0.2%
136	4	0.4%
135	6	0.6%

top_awarded_type
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

hide_score
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

name
Categorical

UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

t3_kqkswb	1
t3_krzlgb	1
t3_kssqhr	1
t3_ktd7xk	1
t3_ks2vo4	1
Other values (985)	985

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	8910
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	990 ?
Unique (%)	100.0%

Sample

1st row	t3_kv4lr7
2nd row	t3_kvg3xu
3rd row	t3_kv4oca
4th row	t3_kvekkt
5th row	t3_kvfqwa

Value	Count	Frequency (%)
t3_kqkswb	1	0.1%
t3_krzlgb	1	0.1%
t3_kssqhr	1	0.1%
t3_ktd7xk	1	0.1%
t3_ks2vo4	1	0.1%
t3_kru3f2	1	0.1%
t3_kv6i5q	1	0.1%
t3_kvhzy8	1	0.1%
t3_krvyex	1	0.1%
t3_ksxsht	1	0.1%
Other values (980)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
t3_kqkswb	1	0.1%
t3_krzlgb	1	0.1%
t3_kssqhr	1	0.1%
t3_ktd7xk	1	0.1%
t3_ks2vo4	1	0.1%
t3_kru3f2	1	0.1%
t3_kv6i5q	1	0.1%
t3_kvhzy8	1	0.1%
t3_krvyex	1	0.1%
t3_ksxsht	1	0.1%
Other values (980)	980	99.0%

Most occurring characters

Value	Count	Frequency (%)
t	1283	14.4%
k	1097	12.3%
3	1090	12.2%
_	990	11.1%
r	358	4.0%
s	349	3.9%
u	252	2.8%
v	220	2.5%
q	168	1.9%
y	131	1.5%
Other values (27)	2972	33.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5851	65.7%
Decimal Number	2069	23.2%
Connector Punctuation	990	11.1%

Most frequent character per category

Value	Count	Frequency (%)
t	1283	21.9%
k	1097	18.7%
r	358	6.1%
s	349	6.0%
u	252	4.3%
v	220	3.8%
q	168	2.9%
y	131	2.2%
z	130	2.2%
f	128	2.2%
Other values (16)	1735	29.7%

Value	Count	Frequency (%)
3	1090	52.7%
4	128	6.2%
5	117	5.7%
0	114	5.5%
8	112	5.4%
1	112	5.4%
7	110	5.3%
9	106	5.1%
2	99	4.8%
6	81	3.9%

Value	Count	Frequency (%)
_	990	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5851	65.7%
Common	3059	34.3%

Most frequent character per script

Value	Count	Frequency (%)
t	1283	21.9%
k	1097	18.7%
r	358	6.1%
s	349	6.0%
u	252	4.3%
v	220	3.8%
q	168	2.9%
y	131	2.2%
z	130	2.2%
f	128	2.2%
Other values (16)	1735	29.7%

Value	Count	Frequency (%)
3	1090	35.6%
_	990	32.4%
4	128	4.2%
5	117	3.8%
0	114	3.7%
8	112	3.7%
1	112	3.7%
7	110	3.6%
9	106	3.5%
2	99	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8910	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	1283	14.4%
k	1097	12.3%
3	1090	12.2%
_	990	11.1%
r	358	4.0%
s	349	3.9%
u	252	2.8%
v	220	2.5%
q	168	1.9%
y	131	1.5%
Other values (27)	2972	33.4%

quarantine
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

link_flair_text_color
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

dark	593
light	397

Length

Max length	5
Median length	4
Mean length	4.401010101
Min length	4

Characters and Unicode

Total characters	4357
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dark
2nd row	dark
3rd row	dark
4th row	dark
5th row	light

Value	Count	Frequency (%)
dark	593	59.9%
light	397	40.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
dark	593	59.9%
light	397	40.1%

Most occurring characters

Value	Count	Frequency (%)
d	593	13.6%
a	593	13.6%
r	593	13.6%
k	593	13.6%
l	397	9.1%
i	397	9.1%
g	397	9.1%
h	397	9.1%
t	397	9.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4357	100.0%

Most frequent character per category

Value	Count	Frequency (%)
d	593	13.6%
a	593	13.6%
r	593	13.6%
k	593	13.6%
l	397	9.1%
i	397	9.1%
g	397	9.1%
h	397	9.1%
t	397	9.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4357	100.0%

Most frequent character per script

Value	Count	Frequency (%)
d	593	13.6%
a	593	13.6%
r	593	13.6%
k	593	13.6%
l	397	9.1%
i	397	9.1%
g	397	9.1%
h	397	9.1%
t	397	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4357	100.0%

Most frequent character per block

Value	Count	Frequency (%)
d	593	13.6%
a	593	13.6%
r	593	13.6%
k	593	13.6%
l	397	9.1%
i	397	9.1%
g	397	9.1%
h	397	9.1%
t	397	9.1%

upvote_ratio
Real number (ℝ_≥0)

Distinct	53
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8589393939
Minimum	0.27
Maximum	1
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 KiB

Quantile statistics

Minimum	0.27
5-th percentile	0.6445
Q1	0.81
median	0.88
Q3	0.94
95-th percentile	0.98
Maximum	1
Range	0.73
Interquartile range (IQR)	0.13

Descriptive statistics

Standard deviation	0.1086147093
Coefficient of variation (CV)	0.1264521223
Kurtosis	2.630048387
Mean	0.8589393939
Median Absolute Deviation (MAD)	0.07
Skewness	-1.372771794
Sum	850.35
Variance	0.01179715507
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.97	57	5.8%
0.96	55	5.6%
0.94	53	5.4%
0.87	47	4.7%
0.92	45	4.5%
0.9	42	4.2%
0.95	41	4.1%
0.93	40	4.0%
0.89	40	4.0%
0.85	39	3.9%
Other values (43)	531	53.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.27	1	0.1%
0.33	1	0.1%
0.4	1	0.1%
0.42	1	0.1%
0.43	1	0.1%

Value	Count	Frequency (%)
1	37	3.7%
0.99	9	0.9%
0.98	26	2.6%
0.97	57	5.8%
0.96	55	5.6%

author_flair_background_color
Categorical

MISSING

Distinct	1
Distinct (%)	10.0%
Missing	980
Missing (%)	99.0%
Memory size	7.7 KiB

	10

Length

Max length	3
Median length	3
Mean length	2.96969697
Min length	0

Characters and Unicode

Total characters	2940
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
	10	1.0%
(Missing)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	980	100.0%

Most occurring characters

Value	Count	Frequency (%)
n	1960	66.7%
a	980	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2940	100.0%

Most frequent character per category

Value	Count	Frequency (%)
n	1960	66.7%
a	980	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2940	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1960	66.7%
a	980	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2940	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1960	66.7%
a	980	33.3%

subreddit_type
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

public	990

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	5940
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	public
2nd row	public
3rd row	public
4th row	public
5th row	public

Value	Count	Frequency (%)
public	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
public	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
p	990	16.7%
u	990	16.7%
b	990	16.7%
l	990	16.7%
i	990	16.7%
c	990	16.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5940	100.0%

Most frequent character per category

Value	Count	Frequency (%)
p	990	16.7%
u	990	16.7%
b	990	16.7%
l	990	16.7%
i	990	16.7%
c	990	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5940	100.0%

Most frequent character per script

Value	Count	Frequency (%)
p	990	16.7%
u	990	16.7%
b	990	16.7%
l	990	16.7%
i	990	16.7%
c	990	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5940	100.0%

Most frequent character per block

Value	Count	Frequency (%)
p	990	16.7%
u	990	16.7%
b	990	16.7%
l	990	16.7%
i	990	16.7%
c	990	16.7%

ups
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	168
Distinct (%)	17.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	97.02929293
Minimum	0
Maximum	6376
Zeros	13
Zeros (%)	1.3%
Memory size	7.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.45
Q1	8
median	15
Q3	35.75
95-th percentile	197.55
Maximum	6376
Range	6376
Interquartile range (IQR)	27.75

Descriptive statistics

Standard deviation	476.4863649
Coefficient of variation (CV)	4.910747575
Kurtosis	88.74509507
Mean	97.02929293
Median Absolute Deviation (MAD)	9
Skewness	8.941137474
Sum	96059
Variance	227039.256
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	46	4.6%
10	42	4.2%
6	40	4.0%
7	40	4.0%
14	37	3.7%
9	36	3.6%
11	35	3.5%
8	35	3.5%
12	33	3.3%
3	33	3.3%
Other values (158)	613	61.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13	1.3%
1	17	1.7%
2	20	2.0%
3	33	3.3%
4	28	2.8%

Value	Count	Frequency (%)
6376	1	0.1%
5601	1	0.1%
5108	1	0.1%
4537	1	0.1%
4339	1	0.1%

total_awards_received
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1222222222
Minimum	0
Maximum	13
Zeros	936
Zeros (%)	94.5%
Memory size	7.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.7957236
Coefficient of variation (CV)	6.510465818
Kurtosis	151.6404542
Mean	0.1222222222
Median Absolute Deviation (MAD)	0
Skewness	11.2402133
Sum	121
Variance	0.6331760476
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	936	94.5%
1	35	3.5%
2	7	0.7%
4	4	0.4%
3	3	0.3%
13	1	0.1%
12	1	0.1%
10	1	0.1%
7	1	0.1%
5	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	936	94.5%
1	35	3.5%
2	7	0.7%
3	3	0.3%
4	4	0.4%

Value	Count	Frequency (%)
13	1	0.1%
12	1	0.1%
10	1	0.1%
7	1	0.1%
5	1	0.1%

media_embed
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

thumbnail_width
Categorical

MISSING

Distinct	2
Distinct (%)	0.2%
Missing	96
Missing (%)	9.7%
Memory size	7.7 KiB

140	893
70	1

Length

Max length	5
Median length	5
Mean length	4.805050505
Min length	3

Characters and Unicode

Total characters	4757
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	nan
2nd row	140.0
3rd row	140.0
4th row	140.0
5th row	140.0

Value	Count	Frequency (%)
140	893	90.2%
70	1	0.1%
(Missing)	96	9.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
140.0	893	90.2%
nan	96	9.7%
70.0	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	1788	37.6%
.	894	18.8%
1	893	18.8%
4	893	18.8%
n	192	4.0%
a	96	2.0%
7	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3575	75.2%
Other Punctuation	894	18.8%
Lowercase Letter	288	6.1%

Most frequent character per category

Value	Count	Frequency (%)
0	1788	50.0%
1	893	25.0%
4	893	25.0%
7	1	< 0.1%

Value	Count	Frequency (%)
n	192	66.7%
a	96	33.3%

Value	Count	Frequency (%)
.	894	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4469	93.9%
Latin	288	6.1%

Most frequent character per script

Value	Count	Frequency (%)
0	1788	40.0%
.	894	20.0%
1	893	20.0%
4	893	20.0%
7	1	< 0.1%

Value	Count	Frequency (%)
n	192	66.7%
a	96	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4757	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	1788	37.6%
.	894	18.8%
1	893	18.8%
4	893	18.8%
n	192	4.0%
a	96	2.0%
7	1	< 0.1%

author_flair_template_id
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

is_original_content
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

user_reports
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

secure_media
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	883
Missing (%)	89.2%
Memory size	7.9 KiB

is_reddit_media_domain
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	567
True	423

Common Values
Chart

Value	Count	Frequency (%)
False	567	57.3%
True	423	42.7%

is_meta
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

category
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

secure_media_embed
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

link_flair_text
Categorical

MISSING

Distinct	25
Distinct (%)	4.6%
Missing	449
Missing (%)	45.4%
Memory size	7.7 KiB

:snoo: Article	94
🗳️ Beat Trump	79
:snoo_joy: Meme	70
article	58
:snoo_smile: Humor	46
Other values (20)	194

Length

Max length	48
Median length	7
Mean length	10.52020202
Min length	3

Characters and Unicode

Total characters	10415
Distinct characters	51
Distinct categories	7 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.7%

Sample

1st row	🔴 Megathread
2nd row	nan
3rd row	nan
4th row	📄Effortpost
5th row	🗳️ Beat Trump

Value	Count	Frequency (%)
:snoo: Article	94	9.5%
🗳️ Beat Trump	79	8.0%
:snoo_joy: Meme	70	7.1%
article	58	5.9%
:snoo_smile: Humor	46	4.6%
📺 Video	43	4.3%
:snoo_feelsgoodman: Discussion :snoo_thoughtful:	37	3.7%
:snoo_putback: Opinion	26	2.6%
:snoo_smile: Satire	17	1.7%
Question :snoo_thoughtful:	13	1.3%
Other values (15)	58	5.9%
(Missing)	449	45.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	449	28.5%
article	152	9.6%
snoo	94	6.0%
beat	79	5.0%
trump	79	5.0%
🗳️	79	5.0%
snoo_joy	70	4.4%
meme	70	4.4%
snoo_smile	63	4.0%
snoo_thoughtful	55	3.5%
Other values (30)	386	24.5%

Most occurring characters

Value	Count	Frequency (%)
n	1451	13.9%
o	1180	11.3%
:	732	7.0%
a	714	6.9%
	681	6.5%
e	675	6.5%
s	636	6.1%
i	450	4.3%
t	449	4.3%
r	356	3.4%
Other values (41)	3091	29.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7942	76.3%
Other Punctuation	732	7.0%
Space Separator	681	6.5%
Uppercase Letter	567	5.4%
Connector Punctuation	265	2.5%
Other Symbol	149	1.4%
Nonspacing Mark	79	0.8%

Most frequent character per category

Value	Count	Frequency (%)
n	1451	18.3%
o	1180	14.9%
a	714	9.0%
e	675	8.5%
s	636	8.0%
i	450	5.7%
t	449	5.7%
r	356	4.5%
u	333	4.2%
l	326	4.1%
Other values (13)	1372	17.3%

Value	Count	Frequency (%)
A	95	16.8%
B	81	14.3%
T	79	13.9%
M	73	12.9%
H	46	8.1%
V	43	7.6%
D	37	6.5%
O	27	4.8%
S	26	4.6%
E	20	3.5%
Other values (5)	40	7.1%

Value	Count	Frequency (%)
🗳	79	53.0%
📺	43	28.9%
📄	9	6.0%
✅	8	5.4%
🔴	3	2.0%
📰	2	1.3%
📉	2	1.3%
📊	2	1.3%
💬	1	0.7%

Value	Count	Frequency (%)
	681	100.0%

Value	Count	Frequency (%)
️	79	100.0%

Value	Count	Frequency (%)
:	732	100.0%

Value	Count	Frequency (%)
_	265	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8509	81.7%
Common	1827	17.5%
Inherited	79	0.8%

Most frequent character per script

Value	Count	Frequency (%)
n	1451	17.1%
o	1180	13.9%
a	714	8.4%
e	675	7.9%
s	636	7.5%
i	450	5.3%
t	449	5.3%
r	356	4.2%
u	333	3.9%
l	326	3.8%
Other values (28)	1939	22.8%

Value	Count	Frequency (%)
:	732	40.1%
	681	37.3%
_	265	14.5%
🗳	79	4.3%
📺	43	2.4%
📄	9	0.5%
✅	8	0.4%
🔴	3	0.2%
📰	2	0.1%
📉	2	0.1%
Other values (2)	3	0.2%

Value	Count	Frequency (%)
️	79	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10187	97.8%
None	141	1.4%
VS	79	0.8%
Dingbats	8	0.1%

Most frequent character per block

Value	Count	Frequency (%)
🗳	79	56.0%
📺	43	30.5%
📄	9	6.4%
🔴	3	2.1%
📰	2	1.4%
📉	2	1.4%
📊	2	1.4%
💬	1	0.7%

Value	Count	Frequency (%)
n	1451	14.2%
o	1180	11.6%
:	732	7.2%
a	714	7.0%
	681	6.7%
e	675	6.6%
s	636	6.2%
i	450	4.4%
t	449	4.4%
r	356	3.5%
Other values (31)	2863	28.1%

Value	Count	Frequency (%)
️	79	100.0%

Value	Count	Frequency (%)
✅	8	100.0%

can_mod_post
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

score
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	168
Distinct (%)	17.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	97.02929293
Minimum	0
Maximum	6376
Zeros	13
Zeros (%)	1.3%
Memory size	7.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.45
Q1	8
median	15
Q3	35.75
95-th percentile	197.55
Maximum	6376
Range	6376
Interquartile range (IQR)	27.75

Descriptive statistics

Standard deviation	476.4863649
Coefficient of variation (CV)	4.910747575
Kurtosis	88.74509507
Mean	97.02929293
Median Absolute Deviation (MAD)	9
Skewness	8.941137474
Sum	96059
Variance	227039.256
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	46	4.6%
10	42	4.2%
6	40	4.0%
7	40	4.0%
14	37	3.7%
9	36	3.6%
11	35	3.5%
8	35	3.5%
12	33	3.3%
3	33	3.3%
Other values (158)	613	61.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13	1.3%
1	17	1.7%
2	20	2.0%
3	33	3.3%
4	28	2.8%

Value	Count	Frequency (%)
6376	1	0.1%
5601	1	0.1%
5108	1	0.1%
4537	1	0.1%
4339	1	0.1%

approved_by
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

author_premium
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	4
Missing (%)	0.4%
Memory size	7.7 KiB

False	698
True	288
(Missing)	4

Common Values
Chart

Value	Count	Frequency (%)
False	698	70.5%
True	288	29.1%
(Missing)	4	0.4%

thumbnail
Categorical

HIGH CARDINALITY

Distinct	881
Distinct (%)	89.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

self	69
default	27
nsfw	10
https://b.thumbs.redditmedia.com/9Uys507Nv1qOzdFiEMP2CfnmhtudbYTfbqUu8H5Q8wc.jpg	2
https://b.thumbs.redditmedia.com/ETTVsydDvB3MRjNVWt7_deJdrEHHSoCQ2OACBZlOcsE.jpg	2
Other values (876)	880

Length

Max length	80
Median length	80
Mean length	71.94444444
Min length	4

Characters and Unicode

Total characters	71225
Distinct characters	67
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	872 ?
Unique (%)	88.1%

Sample

1st row	default
2nd row	https://b.thumbs.redditmedia.com/M36F25Qpk1BhfFggn_BTDeKt1uBhlc1PPDUjpbGUGSg.jpg
3rd row	https://b.thumbs.redditmedia.com/zV6srycz20pOs5oTC-OJA8ZB775smAhjKA37Z92diAg.jpg
4th row	https://b.thumbs.redditmedia.com/9-aJH-bi1cSYsH3t_1SPCYfAWfYguWlTj4Cjd-uvuUw.jpg
5th row	https://b.thumbs.redditmedia.com/vwXKKbri_gr3sZc5k1BzCQBGPFkxbk6M81UHqf1CG9o.jpg

Value	Count	Frequency (%)
self	69	7.0%
default	27	2.7%
nsfw	10	1.0%
https://b.thumbs.redditmedia.com/9Uys507Nv1qOzdFiEMP2CfnmhtudbYTfbqUu8H5Q8wc.jpg	2	0.2%
https://b.thumbs.redditmedia.com/ETTVsydDvB3MRjNVWt7_deJdrEHHSoCQ2OACBZlOcsE.jpg	2	0.2%
https://b.thumbs.redditmedia.com/JDD58YQ254Bq91GGrNLfzBKMfoouuSnwLwtvFY4zBfc.jpg	2	0.2%
https://b.thumbs.redditmedia.com/P7UFAz2qqWCPY6Tagcdt26AWQ1tA4u9JIlcfe4DWXsQ.jpg	2	0.2%
https://b.thumbs.redditmedia.com/yNzaBG6QME42rqbLKLRrbQygmiwIyAmMGSBrvyVI4vs.jpg	2	0.2%
https://b.thumbs.redditmedia.com/cqETkZBxhD93iaH3VpX2P17xp6sDBOpDu3DA9JYCYzg.jpg	2	0.2%
https://b.thumbs.redditmedia.com/Hof5eMtYYfBddxEyCE2BlWN0bTyhmM2x9CeaiqE9-bE.jpg	1	0.1%
Other values (871)	871	88.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
self	69	7.0%
default	27	2.7%
nsfw	10	1.0%
https://b.thumbs.redditmedia.com/ettvsyddvb3mrjnvwt7_dejdrehhsocq2oacbzlocse.jpg	2	0.2%
https://b.thumbs.redditmedia.com/ynzabg6qme42rqblklrrbqygmiwiyammgsbrvyvi4vs.jpg	2	0.2%
https://b.thumbs.redditmedia.com/9uys507nv1qozdfiemp2cfnmhtudbytfbquu8h5q8wc.jpg	2	0.2%
https://b.thumbs.redditmedia.com/jdd58yq254bq91ggrnlfzbkmfoouusnwlwtvfy4zbfc.jpg	2	0.2%
https://b.thumbs.redditmedia.com/cqetkzbxhd93iah3vpx2p17xp6sdbopdu3da9jycyzg.jpg	2	0.2%
https://b.thumbs.redditmedia.com/p7ufaz2qqwcpy6tagcdt26awq1ta4u9jilcfe4dwxsq.jpg	2	0.2%
https://b.thumbs.redditmedia.com/p8rxpqgzzqwq7wa43n1akuzrva87kz57dtovo-1mlbs.jpg	1	0.1%
Other values (871)	871	88.0%

Most occurring characters

Value	Count	Frequency (%)
t	4108	5.8%
.	3536	5.0%
m	3264	4.6%
d	3236	4.5%
/	2652	3.7%
s	2442	3.4%
e	2436	3.4%
h	2364	3.3%
i	2346	3.3%
p	2320	3.3%
Other values (57)	42521	59.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	41474	58.2%
Uppercase Letter	15455	21.7%
Other Punctuation	7072	9.9%
Decimal Number	6080	8.5%
Dash Punctuation	586	0.8%
Connector Punctuation	558	0.8%

Most frequent character per category

Value	Count	Frequency (%)
t	4108	9.9%
m	3264	7.9%
d	3236	7.8%
s	2442	5.9%
e	2436	5.9%
h	2364	5.7%
i	2346	5.7%
p	2320	5.6%
b	2174	5.2%
a	1662	4.0%
Other values (16)	15122	36.5%

Value	Count	Frequency (%)
A	687	4.4%
E	648	4.2%
I	639	4.1%
M	622	4.0%
B	617	4.0%
Q	612	4.0%
C	612	4.0%
U	611	4.0%
L	598	3.9%
K	591	3.8%
Other values (16)	9218	59.6%

Value	Count	Frequency (%)
8	649	10.7%
0	643	10.6%
7	631	10.4%
4	603	9.9%
5	601	9.9%
9	601	9.9%
2	596	9.8%
6	591	9.7%
3	586	9.6%
1	579	9.5%

Value	Count	Frequency (%)
.	3536	50.0%
/	2652	37.5%
:	884	12.5%

Value	Count	Frequency (%)
_	558	100.0%

Value	Count	Frequency (%)
-	586	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56929	79.9%
Common	14296	20.1%

Most frequent character per script

Value	Count	Frequency (%)
t	4108	7.2%
m	3264	5.7%
d	3236	5.7%
s	2442	4.3%
e	2436	4.3%
h	2364	4.2%
i	2346	4.1%
p	2320	4.1%
b	2174	3.8%
a	1662	2.9%
Other values (42)	30577	53.7%

Value	Count	Frequency (%)
.	3536	24.7%
/	2652	18.6%
:	884	6.2%
8	649	4.5%
0	643	4.5%
7	631	4.4%
4	603	4.2%
5	601	4.2%
9	601	4.2%
2	596	4.2%
Other values (5)	2900	20.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71225	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	4108	5.8%
.	3536	5.0%
m	3264	4.6%
d	3236	4.5%
/	2652	3.7%
s	2442	3.4%
e	2436	3.4%
h	2364	3.3%
i	2346	3.3%
p	2320	3.3%
Other values (57)	42521	59.7%

edited
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

author_flair_css_class
Categorical

MISSING

Distinct	1
Distinct (%)	16.7%
Missing	984
Missing (%)	99.4%
Memory size	7.7 KiB

Moderator	6

Length

Max length	9
Median length	3
Mean length	3.036363636
Min length	3

Characters and Unicode

Total characters	3006
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
Moderator	6	0.6%
(Missing)	984	99.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	984	99.4%
moderator	6	0.6%

Most occurring characters

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3000	99.8%
Uppercase Letter	6	0.2%

Most frequent character per category

Value	Count	Frequency (%)
n	1968	65.6%
a	990	33.0%
o	12	0.4%
r	12	0.4%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Value	Count	Frequency (%)
M	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3006	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3006	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

author_flair_richtext
Unsupported

REJECTED
UNSUPPORTED

Missing	4
Missing (%)	0.4%
Memory size	7.9 KiB

gildings
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

post_hint
Categorical

MISSING

Distinct	5
Distinct (%)	0.6%
Missing	97
Missing (%)	9.8%
Memory size	7.7 KiB

image	436
link	384
rich:video	67
hosted:video	3
self	3

Length

Max length	12
Median length	5
Mean length	4.772727273
Min length	3

Characters and Unicode

Total characters	4725
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	link
2nd row	image
3rd row	image
4th row	image
5th row	image

Value	Count	Frequency (%)
image	436	44.0%
link	384	38.8%
rich:video	67	6.8%
hosted:video	3	0.3%
self	3	0.3%
(Missing)	97	9.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
image	436	44.0%
link	384	38.8%
nan	97	9.8%
rich:video	67	6.8%
hosted:video	3	0.3%
self	3	0.3%

Most occurring characters

Value	Count	Frequency (%)
i	957	20.3%
n	578	12.2%
a	533	11.3%
e	512	10.8%
m	436	9.2%
g	436	9.2%
l	387	8.2%
k	384	8.1%
d	73	1.5%
o	73	1.5%
Other values (8)	356	7.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4655	98.5%
Other Punctuation	70	1.5%

Most frequent character per category

Value	Count	Frequency (%)
i	957	20.6%
n	578	12.4%
a	533	11.5%
e	512	11.0%
m	436	9.4%
g	436	9.4%
l	387	8.3%
k	384	8.2%
d	73	1.6%
o	73	1.6%
Other values (7)	286	6.1%

Value	Count	Frequency (%)
:	70	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4655	98.5%
Common	70	1.5%

Most frequent character per script

Value	Count	Frequency (%)
i	957	20.6%
n	578	12.4%
a	533	11.5%
e	512	11.0%
m	436	9.4%
g	436	9.4%
l	387	8.3%
k	384	8.2%
d	73	1.6%
o	73	1.6%
Other values (7)	286	6.1%

Value	Count	Frequency (%)
:	70	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4725	100.0%

Most frequent character per block

Value	Count	Frequency (%)
i	957	20.3%
n	578	12.2%
a	533	11.3%
e	512	10.8%
m	436	9.2%
g	436	9.2%
l	387	8.2%
k	384	8.1%
d	73	1.5%
o	73	1.5%
Other values (8)	356	7.5%

content_categories
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

is_self
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	920
True	70

Common Values
Chart

Value	Count	Frequency (%)
False	920	92.9%
True	70	7.1%

mod_note
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

crosspost_parent_list
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	977
Missing (%)	98.7%
Memory size	7.9 KiB

created
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1610118243
Minimum	1609714444
Maximum	1610462189
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 KiB

Quantile statistics

Minimum	1609714444
5-th percentile	1609843988
Q1	1609993329
median	1610088143
Q3	1610251865
95-th percentile	1610430603
Maximum	1610462189
Range	747745
Interquartile range (IQR)	258535.75

Descriptive statistics

Standard deviation	173770.9156
Coefficient of variation (CV)	0.0001079243195
Kurtosis	-0.8019262211
Mean	1610118243
Median Absolute Deviation (MAD)	108261.5
Skewness	0.2728621604
Sum	1.59401706 × 10¹²
Variance	3.019633112 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1610339344	1	0.1%
1610358631	1	0.1%
1610373234	1	0.1%
1610024211	1	0.1%
1610174258	1	0.1%
1610001294	1	0.1%
1610371557	1	0.1%
1609950832	1	0.1%
1610145829	1	0.1%
1610010570	1	0.1%
Other values (980)	980	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1609714444	1	0.1%
1609736233	1	0.1%
1609752958	1	0.1%
1609754265	1	0.1%
1609763214	1	0.1%

Value	Count	Frequency (%)
1610462189	1	0.1%
1610460979	1	0.1%
1610460821	1	0.1%
1610460543	1	0.1%
1610459844	1	0.1%

link_flair_type
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

richtext	541
text	449

Length

Max length	8
Median length	8
Mean length	6.185858586
Min length	4

Characters and Unicode

Total characters	6124
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	richtext
2nd row	text
3rd row	text
4th row	richtext
5th row	richtext

Value	Count	Frequency (%)
richtext	541	54.6%
text	449	45.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
richtext	541	54.6%
text	449	45.4%

Most occurring characters

Value	Count	Frequency (%)
t	1980	32.3%
e	990	16.2%
x	990	16.2%
r	541	8.8%
i	541	8.8%
c	541	8.8%
h	541	8.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6124	100.0%

Most frequent character per category

Value	Count	Frequency (%)
t	1980	32.3%
e	990	16.2%
x	990	16.2%
r	541	8.8%
i	541	8.8%
c	541	8.8%
h	541	8.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6124	100.0%

Most frequent character per script

Value	Count	Frequency (%)
t	1980	32.3%
e	990	16.2%
x	990	16.2%
r	541	8.8%
i	541	8.8%
c	541	8.8%
h	541	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6124	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	1980	32.3%
e	990	16.2%
x	990	16.2%
r	541	8.8%
i	541	8.8%
c	541	8.8%
h	541	8.8%

wls
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

6	980
3	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	990
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	6
2nd row	6
3rd row	6
4th row	6
5th row	6

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

Most occurring characters

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	990	100.0%

Most frequent character per category

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	990	100.0%

Most frequent character per script

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	990	100.0%

Most frequent character per block

Value	Count	Frequency (%)
6	980	99.0%
3	10	1.0%

removed_by_category
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

banned_by
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

author_flair_type
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	4
Missing (%)	0.4%
Memory size	7.7 KiB

text	980
richtext	6

Length

Max length	8
Median length	4
Mean length	4.02020202
Min length	3

Characters and Unicode

Total characters	3980
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	text
2nd row	text
3rd row	text
4th row	text
5th row	text

Value	Count	Frequency (%)
text	980	99.0%
richtext	6	0.6%
(Missing)	4	0.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
text	980	99.0%
richtext	6	0.6%
nan	4	0.4%

Most occurring characters

Value	Count	Frequency (%)
t	1972	49.5%
e	986	24.8%
x	986	24.8%
n	8	0.2%
r	6	0.2%
i	6	0.2%
c	6	0.2%
h	6	0.2%
a	4	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3980	100.0%

Most frequent character per category

Value	Count	Frequency (%)
t	1972	49.5%
e	986	24.8%
x	986	24.8%
n	8	0.2%
r	6	0.2%
i	6	0.2%
c	6	0.2%
h	6	0.2%
a	4	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3980	100.0%

Most frequent character per script

Value	Count	Frequency (%)
t	1972	49.5%
e	986	24.8%
x	986	24.8%
n	8	0.2%
r	6	0.2%
i	6	0.2%
c	6	0.2%
h	6	0.2%
a	4	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3980	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	1972	49.5%
e	986	24.8%
x	986	24.8%
n	8	0.2%
r	6	0.2%
i	6	0.2%
c	6	0.2%
h	6	0.2%
a	4	0.1%

domain
Categorical

HIGH CARDINALITY

Distinct	148
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

i.redd.it	420
self.democrats	70
youtu.be	47
twitter.com	37
cnn.com	26
Other values (143)	390

Length

Max length	43
Median length	9
Mean length	10.8
Min length	6

Characters and Unicode

Total characters	10692
Distinct characters	36
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	90 ?
Unique (%)	9.1%

Sample

1st row	self.JoeBiden
2nd row	i.redd.it
3rd row	i.redd.it
4th row	i.redd.it
5th row	i.redd.it

Value	Count	Frequency (%)
i.redd.it	420	42.4%
self.democrats	70	7.1%
youtu.be	47	4.7%
twitter.com	37	3.7%
cnn.com	26	2.6%
thehill.com	22	2.2%
youtube.com	19	1.9%
nbcnews.com	15	1.5%
i.imgur.com	14	1.4%
apnews.com	14	1.4%
Other values (138)	306	30.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
i.redd.it	420	42.4%
self.democrats	70	7.1%
youtu.be	47	4.7%
twitter.com	37	3.7%
cnn.com	26	2.6%
thehill.com	22	2.2%
youtube.com	19	1.9%
nbcnews.com	15	1.5%
apnews.com	14	1.4%
i.imgur.com	14	1.4%
Other values (138)	306	30.9%

Most occurring characters

Value	Count	Frequency (%)
.	1489	13.9%
i	1154	10.8%
d	1018	9.5%
e	1013	9.5%
t	932	8.7%
o	777	7.3%
r	680	6.4%
c	626	5.9%
m	582	5.4%
s	388	3.6%
Other values (26)	2033	19.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9183	85.9%
Other Punctuation	1489	13.9%
Decimal Number	12	0.1%
Uppercase Letter	6	0.1%
Dash Punctuation	2	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
i	1154	12.6%
d	1018	11.1%
e	1013	11.0%
t	932	10.1%
o	777	8.5%
r	680	7.4%
c	626	6.8%
m	582	6.3%
s	388	4.2%
n	325	3.5%
Other values (16)	1688	18.4%

Value	Count	Frequency (%)
1	3	25.0%
2	3	25.0%
4	2	16.7%
3	2	16.7%
7	1	8.3%
9	1	8.3%

Value	Count	Frequency (%)
J	3	50.0%
B	3	50.0%

Value	Count	Frequency (%)
.	1489	100.0%

Value	Count	Frequency (%)
-	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9189	85.9%
Common	1503	14.1%

Most frequent character per script

Value	Count	Frequency (%)
i	1154	12.6%
d	1018	11.1%
e	1013	11.0%
t	932	10.1%
o	777	8.5%
r	680	7.4%
c	626	6.8%
m	582	6.3%
s	388	4.2%
n	325	3.5%
Other values (18)	1694	18.4%

Value	Count	Frequency (%)
.	1489	99.1%
1	3	0.2%
2	3	0.2%
4	2	0.1%
3	2	0.1%
-	2	0.1%
7	1	0.1%
9	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10692	100.0%

Most frequent character per block

Value	Count	Frequency (%)
.	1489	13.9%
i	1154	10.8%
d	1018	9.5%
e	1013	9.5%
t	932	8.7%
o	777	7.3%
r	680	6.4%
c	626	5.9%
m	582	5.4%
s	388	3.6%
Other values (26)	2033	19.0%

allow_live_comments
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	877
True	113

Common Values
Chart

Value	Count	Frequency (%)
False	877	88.6%
True	113	11.4%

selftext_html
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	57
Distinct (%)	100.0%
Missing	933
Missing (%)	94.2%
Memory size	7.7 KiB

<!-- SC_OFF --><div class="md"><p>Remember the actions taken</p> <p>Remember the reactions</p> <p>Remember who offered support</p> <p>Remember who condemned chaos</p> <p>Remember who was silent</p> <p>Remember who was loud</p> <p>Remember who was violent and chaotic</p> <p>Remember who was peaceful and resilient</p> </div><!-- SC_ON -->	1
<!-- SC_OFF --><div class="md"><p>I was born in Havana, Cuba. Came to the US in the ‘80s, became old enough to vote in 1997 and voted for the first time in 2000. I voted for Bush twice, McCain, Romney, and Trump in 2016. Thanks to Trump’s reckless administration, I learned I was being used so I left the Republican Party in 2017. I became a Democrat in 2019, and voted Democratic for the first time of my life, and that Democrat was Joe Biden for POTUS.</p> </div><!-- SC_ON -->	1
<!-- SC_OFF --><div class="md"><p>and that’s universal healthcare, a living wage, universal childcare, more access to higher education, and a progressive tax rate. Because that’s what you fucking deserve.</p> </div><!-- SC_ON -->	1
<!-- SC_OFF --><div class="md"><p>Don&#39;t think the idea lesson protesters are white Republicans and that we need to let up on this position now</p> </div><!-- SC_ON -->	1
<!-- SC_OFF --><div class="md"><p>I may live in the deathscape known as West Virginia, but I just wanted to say that I believe in you, Georgia. We can do this! Let’s get these two wins and get rid of the Turtle!</p> </div><!-- SC_ON -->	1
Other values (52)	52

Length

Max length	7487
Median length	3
Mean length	36.75353535
Min length	3

Characters and Unicode

Total characters	36386
Distinct characters	89
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	57 ?
Unique (%)	100.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
<!-- SC_OFF --><div class="md"><p>Remember the actions taken</p> <p>Remember the reactions</p> <p>Remember who offered support</p> <p>Remember who condemned chaos</p> <p>Remember who was silent</p> <p>Remember who was loud</p> <p>Remember who was violent and chaotic</p> <p>Remember who was peaceful and resilient</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>I was born in Havana, Cuba. Came to the US in the ‘80s, became old enough to vote in 1997 and voted for the first time in 2000. I voted for Bush twice, McCain, Romney, and Trump in 2016. Thanks to Trump’s reckless administration, I learned I was being used so I left the Republican Party in 2017. I became a Democrat in 2019, and voted Democratic for the first time of my life, and that Democrat was Joe Biden for POTUS.</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>and that’s universal healthcare, a living wage, universal childcare, more access to higher education, and a progressive tax rate. Because that’s what you fucking deserve.</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>Don&#39;t think the idea lesson protesters are white Republicans and that we need to let up on this position now</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>I may live in the deathscape known as West Virginia, but I just wanted to say that I believe in you, Georgia. We can do this! Let’s get these two wins and get rid of the Turtle!</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>It&#39;s been a long run. Thank you Stacey Abrams about both of Georgia&#39;s new, blue Senators for pushing it this far. The last 4 years were hard and November was agonizing. This feels like it could be a positive turn that I&#39;m ready to believe in.</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>Senators Raphael Warnock and Jon Ossoff</p> <p>Minority Leader Mitch McConnell</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>I&#39;m just beside myself trying to understand how the vote tally&#39;s aren&#39;t exactly the same. </p> <p>Or is this an instance of people proactively voting for a specific person (Warnock), over just voting party lines.</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>Your responsible: </p> <p>Marsha Blackburn of Tennessee Mike Braun of Indiana Ted Cruz of Texas Steve Daines of Montana Bill Hagerty of Tennessee Josh Hawley of Missouri Ron Johnson of Wisconsin John Kennedy of Louisiana James Lankford of Oklahoma Cynthia Lummis of Wyoming Roger Marshall of Kansas Rick Scott of Florida Tommy Tuberville of Alabama Kelly Loeffler of Georgia</p> </div><!-- SC_ON -->	1	0.1%
<!-- SC_OFF --><div class="md"><p>With the Democratic Party having majority of the House, the Senate and the Presidency, I figured now would be a good time to gauge how at least the next 4 years will go and how the people think it should go in regards to gun control.</p> </div><!-- SC_ON -->	1	0.1%
Other values (47)	47	4.7%
(Missing)	933	94.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	933	16.3%
the	225	3.9%
to	127	2.2%
of	104	1.8%
a	101	1.8%
and	100	1.7%
in	76	1.3%
i	70	1.2%
that	59	1.0%
sc_on	57	1.0%
Other values (1546)	3880	67.7%

Most occurring characters

Value	Count	Frequency (%)
	4625	12.7%
n	3241	8.9%
t	2854	7.8%
a	2659	7.3%
e	2463	6.8%
o	1560	4.3%
i	1478	4.1%
l	1368	3.8%
s	1305	3.6%
;	1220	3.4%
Other values (79)	13613	37.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	25758	70.8%
Space Separator	4625	12.7%
Other Punctuation	3403	9.4%
Uppercase Letter	1304	3.6%
Dash Punctuation	491	1.3%
Decimal Number	393	1.1%
Control	187	0.5%
Connector Punctuation	114	0.3%
Math Symbol	68	0.2%
Final Punctuation	19	0.1%
Other values (5)	24	0.1%

Most frequent character per category

Value	Count	Frequency (%)
n	3241	12.6%
t	2854	11.1%
a	2659	10.3%
e	2463	9.6%
o	1560	6.1%
i	1478	5.7%
l	1368	5.3%
s	1305	5.1%
r	1142	4.4%
h	1014	3.9%
Other values (16)	6674	25.9%

Value	Count	Frequency (%)
S	155	11.9%
C	152	11.7%
I	145	11.1%
O	137	10.5%
F	128	9.8%
T	81	6.2%
N	77	5.9%
A	62	4.8%
R	56	4.3%
W	42	3.2%
Other values (15)	269	20.6%

Value	Count	Frequency (%)
;	1220	35.9%
&	1100	32.3%
.	266	7.8%
/	244	7.2%
,	178	5.2%
"	128	3.8%
!	123	3.6%
#	87	2.6%
?	29	0.9%
:	19	0.6%
Other values (4)	9	0.3%

Value	Count	Frequency (%)
3	100	25.4%
9	97	24.7%
2	53	13.5%
0	44	11.2%
1	37	9.4%
5	17	4.3%
8	15	3.8%
6	13	3.3%
7	11	2.8%
4	6	1.5%

Value	Count	Frequency (%)
-	490	99.8%
–	1	0.2%

Value	Count	Frequency (%)
’	18	94.7%
”	1	5.3%

Value	Count	Frequency (%)
“	1	50.0%
‘	1	50.0%

Value	Count	Frequency (%)
	4625	100.0%

Value	Count	Frequency (%)
_	114	100.0%

Value	Count	Frequency (%)
=	68	100.0%

Value	Count	Frequency (%)
	187	100.0%

Value	Count	Frequency (%)
(	9	100.0%

Value	Count	Frequency (%)
)	9	100.0%

Value	Count	Frequency (%)
$	3	100.0%

Value	Count	Frequency (%)
🌊	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27062	74.4%
Common	9324	25.6%

Most frequent character per script

Value	Count	Frequency (%)
n	3241	12.0%
t	2854	10.5%
a	2659	9.8%
e	2463	9.1%
o	1560	5.8%
i	1478	5.5%
l	1368	5.1%
s	1305	4.8%
r	1142	4.2%
h	1014	3.7%
Other values (41)	7978	29.5%

Value	Count	Frequency (%)
	4625	49.6%
;	1220	13.1%
&	1100	11.8%
-	490	5.3%
.	266	2.9%
/	244	2.6%
	187	2.0%
,	178	1.9%
"	128	1.4%
!	123	1.3%
Other values (28)	763	8.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36358	99.9%
Punctuation	23	0.1%
None	5	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
	4625	12.7%
n	3241	8.9%
t	2854	7.8%
a	2659	7.3%
e	2463	6.8%
o	1560	4.3%
i	1478	4.1%
l	1368	3.8%
s	1305	3.6%
;	1220	3.4%
Other values (71)	13585	37.4%

Value	Count	Frequency (%)
’	18	78.3%
–	1	4.3%
“	1	4.3%
”	1	4.3%
…	1	4.3%
‘	1	4.3%

Value	Count	Frequency (%)
§	4	80.0%
🌊	1	20.0%

likes
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

suggested_sort
Categorical

MISSING

Distinct	2
Distinct (%)	50.0%
Missing	986
Missing (%)	99.6%
Memory size	7.7 KiB

new	3
confidence	1

Length

Max length	10
Median length	3
Mean length	3.007070707
Min length	3

Characters and Unicode

Total characters	2977
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	25.0%

Sample

1st row	new
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
new	3	0.3%
confidence	1	0.1%
(Missing)	986	99.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	986	99.6%
new	3	0.3%
confidence	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	1977	66.4%
a	986	33.1%
e	5	0.2%
w	3	0.1%
c	2	0.1%
o	1	< 0.1%
f	1	< 0.1%
i	1	< 0.1%
d	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2977	100.0%

Most frequent character per category

Value	Count	Frequency (%)
n	1977	66.4%
a	986	33.1%
e	5	0.2%
w	3	0.1%
c	2	0.1%
o	1	< 0.1%
f	1	< 0.1%
i	1	< 0.1%
d	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2977	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1977	66.4%
a	986	33.1%
e	5	0.2%
w	3	0.1%
c	2	0.1%
o	1	< 0.1%
f	1	< 0.1%
i	1	< 0.1%
d	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2977	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1977	66.4%
a	986	33.1%
e	5	0.2%
w	3	0.1%
c	2	0.1%
o	1	< 0.1%
f	1	< 0.1%
i	1	< 0.1%
d	1	< 0.1%

banned_at_utc
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

url_overridden_by_dest
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	916
Distinct (%)	99.6%
Missing	70
Missing (%)	7.1%
Memory size	7.7 KiB

https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576/	2
https://www.bbc.co.uk/news/technology-55569604	2
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2
https://www.politico.com/news/2021/01/06/biden-to-tap-merrick-garland-for-attorney-general-455410	1
Other values (911)	911

Length

Max length	341
Median length	35
Mean length	58.3020202
Min length	3

Characters and Unicode

Total characters	57719
Distinct characters	73
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	912 ?
Unique (%)	99.1%

Sample

1st row	/r/JoeBiden/comments/kv4jen/house_democrats_launch_second_impeachment_of/
2nd row	https://i.redd.it/sq8b597wpsa61.jpg
3rd row	https://i.redd.it/ewmxi3oh0qa61.jpg
4th row	https://i.redd.it/863qmtjcbsa61.jpg
5th row	https://i.redd.it/nil93j0cmsa61.jpg

Value	Count	Frequency (%)
https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576/	2	0.2%
https://www.bbc.co.uk/news/technology-55569604	2	0.2%
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2	0.2%
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2	0.2%
https://www.politico.com/news/2021/01/06/biden-to-tap-merrick-garland-for-attorney-general-455410	1	0.1%
https://www.fbi.gov/contact-us/field-offices/washingtondc/news/fbi-seeking-information-related-to-violent-activity-at-the-us-capitol-building	1	0.1%
https://i.redd.it/bc2c328z9t961.jpg	1	0.1%
https://i.redd.it/atjmajk1ld961.jpg	1	0.1%
https://apnews.com/article/joe-biden-politics-lisa-monaco-merrick-garland-courts-e7972db4cd96352d028af3167b253481	1	0.1%
https://i.redd.it/wn7v2yav5ca61.jpg	1	0.1%
Other values (906)	906	91.5%
(Missing)	70	7.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	70	7.1%
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2	0.2%
https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576	2	0.2%
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2	0.2%
https://www.bbc.co.uk/news/technology-55569604	2	0.2%
https://twitter.com/realdonaldtrump/status/1287877621380837378?ref_src=twsrc%5etfw%7ctwcamp%5etweetembed%7ctwterm%5e1287877621380837378%7ctwgr%5e%7ctwcon%5es1_&ref_url=https%3a%2f%2fwww.cbs17.com%2fnews%2fnational-news%2ftrump-tweet-threatening-prison-time-for-those-who-protest-at-federal-buildings-resurfaces-amid-capitol-hill-chaos%2f	1	0.1%
https://i.redd.it/c3hrmczb32a61.jpg	1	0.1%
https://i.redd.it/webvfod2bx961.png	1	0.1%
https://www.fbi.gov/contact-us/field-offices/washingtondc/news/fbi-seeking-information-related-to-violent-activity-at-the-us-capitol-building	1	0.1%
https://i.redd.it/b1i1utxswfa61.jpg	1	0.1%
Other values (907)	907	91.6%

Most occurring characters

Value	Count	Frequency (%)
t	4710	8.2%
/	3836	6.6%
e	3257	5.6%
i	2946	5.1%
s	2902	5.0%
-	2681	4.6%
o	2430	4.2%
p	2391	4.1%
a	2322	4.0%
.	2245	3.9%
Other values (63)	27999	48.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	40690	70.5%
Other Punctuation	7158	12.4%
Decimal Number	6303	10.9%
Dash Punctuation	2681	4.6%
Uppercase Letter	668	1.2%
Connector Punctuation	121	0.2%
Math Symbol	98	0.2%

Most frequent character per category

Value	Count	Frequency (%)
t	4710	11.6%
e	3257	8.0%
i	2946	7.2%
s	2902	7.1%
o	2430	6.0%
p	2391	5.9%
a	2322	5.7%
r	2228	5.5%
n	2072	5.1%
d	1809	4.4%
Other values (16)	13623	33.5%

Value	Count	Frequency (%)
S	43	6.4%
C	42	6.3%
B	40	6.0%
U	35	5.2%
P	32	4.8%
R	32	4.8%
F	32	4.8%
I	31	4.6%
T	29	4.3%
H	28	4.2%
Other values (16)	324	48.5%

Value	Count	Frequency (%)
1	1252	19.9%
6	870	13.8%
0	778	12.3%
2	727	11.5%
9	587	9.3%
5	483	7.7%
3	431	6.8%
4	410	6.5%
7	388	6.2%
8	377	6.0%

Value	Count	Frequency (%)
/	3836	53.6%
.	2245	31.4%
:	917	12.8%
?	73	1.0%
%	32	0.4%
&	26	0.4%
;	26	0.4%
#	3	< 0.1%

Value	Count	Frequency (%)
_	121	100.0%

Value	Count	Frequency (%)
-	2681	100.0%

Value	Count	Frequency (%)
=	98	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41358	71.7%
Common	16361	28.3%

Most frequent character per script

Value	Count	Frequency (%)
t	4710	11.4%
e	3257	7.9%
i	2946	7.1%
s	2902	7.0%
o	2430	5.9%
p	2391	5.8%
a	2322	5.6%
r	2228	5.4%
n	2072	5.0%
d	1809	4.4%
Other values (42)	14291	34.6%

Value	Count	Frequency (%)
/	3836	23.4%
-	2681	16.4%
.	2245	13.7%
1	1252	7.7%
:	917	5.6%
6	870	5.3%
0	778	4.8%
2	727	4.4%
9	587	3.6%
5	483	3.0%
Other values (11)	1985	12.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57719	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	4710	8.2%
/	3836	6.6%
e	3257	5.6%
i	2946	5.1%
s	2902	5.0%
-	2681	4.6%
o	2430	4.2%
p	2391	4.1%
a	2322	4.0%
.	2245	3.9%
Other values (63)	27999	48.5%

view_count
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

archived
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

no_follow
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	953
True	37

Common Values
Chart

Value	Count	Frequency (%)
False	953	96.3%
True	37	3.7%

is_crosspostable
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

pinned
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

over_18
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	980
True	10

Common Values
Chart

Value	Count	Frequency (%)
False	980	99.0%
True	10	1.0%

preview
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	97
Missing (%)	9.8%
Memory size	7.9 KiB

all_awardings
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

awarders
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

media_only
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

link_flair_template_id
Categorical

MISSING

Distinct	23
Distinct (%)	4.8%
Missing	510
Missing (%)	51.5%
Memory size	7.7 KiB

ec699eba-dd59-11ea-8dc8-0ecbe56cff1d	94
d5bbc84c-dd58-11ea-b388-0e8e81330acb	79
fc8afa6e-dd59-11ea-8541-0e09e4b7c31f	70
ef599158-2dbc-11eb-a4b2-0e1a5aebf877	46
e16437a2-dd57-11ea-a85d-0e32d293b691	43
Other values (18)	148

Length

Max length	36
Median length	3
Mean length	19
Min length	3

Characters and Unicode

Total characters	18810
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.8%

Sample

1st row	67d78188-5420-11eb-8a07-0e0fd072bff5
2nd row	nan
3rd row	nan
4th row	1a2d922c-dd58-11ea-812c-0e3b77e24cb9
5th row	d5bbc84c-dd58-11ea-b388-0e8e81330acb

Value	Count	Frequency (%)
ec699eba-dd59-11ea-8dc8-0ecbe56cff1d	94	9.5%
d5bbc84c-dd58-11ea-b388-0e8e81330acb	79	8.0%
fc8afa6e-dd59-11ea-8541-0e09e4b7c31f	70	7.1%
ef599158-2dbc-11eb-a4b2-0e1a5aebf877	46	4.6%
e16437a2-dd57-11ea-a85d-0e32d293b691	43	4.3%
0bf3b48c-dd5a-11ea-891c-0eb295b8865f	37	3.7%
fe9e95e2-dd57-11ea-bfc9-0e97de11b9ef	26	2.6%
2fd2a1b2-dd58-11ea-be1a-0e61f7f81e33	17	1.7%
366aed66-dd5a-11ea-84d2-0e5d79fe92b3	13	1.3%
46d6e85a-dd58-11ea-a039-0e4e897c1c31	11	1.1%
Other values (13)	44	4.4%
(Missing)	510	51.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	510	51.5%
ec699eba-dd59-11ea-8dc8-0ecbe56cff1d	94	9.5%
d5bbc84c-dd58-11ea-b388-0e8e81330acb	79	8.0%
fc8afa6e-dd59-11ea-8541-0e09e4b7c31f	70	7.1%
ef599158-2dbc-11eb-a4b2-0e1a5aebf877	46	4.6%
e16437a2-dd57-11ea-a85d-0e32d293b691	43	4.3%
0bf3b48c-dd5a-11ea-891c-0eb295b8865f	37	3.7%
fe9e95e2-dd57-11ea-bfc9-0e97de11b9ef	26	2.6%
2fd2a1b2-dd58-11ea-be1a-0e61f7f81e33	17	1.7%
366aed66-dd5a-11ea-84d2-0e5d79fe92b3	13	1.3%
Other values (14)	55	5.6%

Most occurring characters

Value	Count	Frequency (%)
-	1920	10.2%
e	1857	9.9%
1	1715	9.1%
a	1638	8.7%
d	1389	7.4%
8	1283	6.8%
b	1099	5.8%
5	1035	5.5%
n	1020	5.4%
c	1016	5.4%
Other values (8)	4838	25.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8756	46.5%
Decimal Number	8134	43.2%
Dash Punctuation	1920	10.2%

Most frequent character per category

Value	Count	Frequency (%)
1	1715	21.1%
8	1283	15.8%
5	1035	12.7%
9	930	11.4%
0	714	8.8%
3	606	7.5%
6	519	6.4%
2	462	5.7%
4	455	5.6%
7	415	5.1%

Value	Count	Frequency (%)
e	1857	21.2%
a	1638	18.7%
d	1389	15.9%
b	1099	12.6%
n	1020	11.6%
c	1016	11.6%
f	737	8.4%

Value	Count	Frequency (%)
-	1920	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10054	53.5%
Latin	8756	46.5%

Most frequent character per script

Value	Count	Frequency (%)
-	1920	19.1%
1	1715	17.1%
8	1283	12.8%
5	1035	10.3%
9	930	9.3%
0	714	7.1%
3	606	6.0%
6	519	5.2%
2	462	4.6%
4	455	4.5%

Value	Count	Frequency (%)
e	1857	21.2%
a	1638	18.7%
d	1389	15.9%
b	1099	12.6%
n	1020	11.6%
c	1016	11.6%
f	737	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18810	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	1920	10.2%
e	1857	9.9%
1	1715	9.1%
a	1638	8.7%
d	1389	7.4%
8	1283	6.8%
b	1099	5.8%
5	1035	5.5%
n	1020	5.4%
c	1016	5.4%
Other values (8)	4838	25.7%

can_gild
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

spoiler
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

locked
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

author_flair_text
Categorical

MISSING

Distinct	1
Distinct (%)	16.7%
Missing	984
Missing (%)	99.4%
Memory size	7.7 KiB

Moderator	6

Length

Max length	9
Median length	3
Mean length	3.036363636
Min length	3

Characters and Unicode

Total characters	3006
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
Moderator	6	0.6%
(Missing)	984	99.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	984	99.4%
moderator	6	0.6%

Most occurring characters

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3000	99.8%
Uppercase Letter	6	0.2%

Most frequent character per category

Value	Count	Frequency (%)
n	1968	65.6%
a	990	33.0%
o	12	0.4%
r	12	0.4%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Value	Count	Frequency (%)
M	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3006	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3006	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1968	65.5%
a	990	32.9%
o	12	0.4%
r	12	0.4%
M	6	0.2%
d	6	0.2%
e	6	0.2%
t	6	0.2%

treatment_tags
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

visited
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

removed_by
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

num_reports
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

distinguished
Categorical

MISSING

Distinct	1
Distinct (%)	50.0%
Missing	988
Missing (%)	99.8%
Memory size	7.7 KiB

moderator	2

Length

Max length	9
Median length	3
Mean length	3.012121212
Min length	3

Characters and Unicode

Total characters	2982
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
moderator	2	0.2%
(Missing)	988	99.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	988	99.8%
moderator	2	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	1976	66.3%
a	990	33.2%
o	4	0.1%
r	4	0.1%
m	2	0.1%
d	2	0.1%
e	2	0.1%
t	2	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2982	100.0%

Most frequent character per category

Value	Count	Frequency (%)
n	1976	66.3%
a	990	33.2%
o	4	0.1%
r	4	0.1%
m	2	0.1%
d	2	0.1%
e	2	0.1%
t	2	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2982	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1976	66.3%
a	990	33.2%
o	4	0.1%
r	4	0.1%
m	2	0.1%
d	2	0.1%
e	2	0.1%
t	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2982	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1976	66.3%
a	990	33.2%
o	4	0.1%
r	4	0.1%
m	2	0.1%
d	2	0.1%
e	2	0.1%
t	2	0.1%

subreddit_id
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

t5_2qn70	990

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	7920
Distinct characters	8
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	t5_2qn70
2nd row	t5_2qn70
3rd row	t5_2qn70
4th row	t5_2qn70
5th row	t5_2qn70

Value	Count	Frequency (%)
t5_2qn70	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
t5_2qn70	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
t	990	12.5%
5	990	12.5%
_	990	12.5%
2	990	12.5%
q	990	12.5%
n	990	12.5%
7	990	12.5%
0	990	12.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3960	50.0%
Lowercase Letter	2970	37.5%
Connector Punctuation	990	12.5%

Most frequent character per category

Value	Count	Frequency (%)
5	990	25.0%
2	990	25.0%
7	990	25.0%
0	990	25.0%

Value	Count	Frequency (%)
t	990	33.3%
q	990	33.3%
n	990	33.3%

Value	Count	Frequency (%)
_	990	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4950	62.5%
Latin	2970	37.5%

Most frequent character per script

Value	Count	Frequency (%)
5	990	20.0%
_	990	20.0%
2	990	20.0%
7	990	20.0%
0	990	20.0%

Value	Count	Frequency (%)
t	990	33.3%
q	990	33.3%
n	990	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7920	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	990	12.5%
5	990	12.5%
_	990	12.5%
2	990	12.5%
q	990	12.5%
n	990	12.5%
7	990	12.5%
0	990	12.5%

mod_reason_by
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

removal_reason
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

link_flair_background_color
Categorical

Distinct	18
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

	556
#5f9dd2	94
#ff0000	79
#349e48	70
#ff4500	45
Other values (13)	146

Length

Max length	7
Median length	0
Mean length	3.068686869
Min length	0

Characters and Unicode

Total characters	3038
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.2%

Sample

1st row	#ffffff
2nd row
3rd row
4th row	#ffd635
5th row	#ff0000

Value	Count	Frequency (%)
	556	56.2%
#5f9dd2	94	9.5%
#ff0000	79	8.0%
#349e48	70	7.1%
#ff4500	45	4.5%
#b8001f	43	4.3%
#cc5289	26	2.6%
#ffb000	17	1.7%
#ffd635	16	1.6%
#0079d3	13	1.3%
Other values (8)	31	3.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
5f9dd2	94	21.7%
ff0000	79	18.2%
349e48	70	16.1%
ff4500	45	10.4%
b8001f	43	9.9%
cc5289	26	6.0%
ffb000	17	3.9%
ffd635	16	3.7%
0079d3	13	3.0%
228b22	11	2.5%
Other values (7)	20	4.6%

Most occurring characters

Value	Count	Frequency (%)
0	581	19.1%
f	475	15.6%
#	434	14.3%
d	220	7.2%
9	209	6.9%
4	205	6.7%
5	182	6.0%
2	167	5.5%
8	150	4.9%
3	116	3.8%
Other values (7)	299	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1698	55.9%
Lowercase Letter	906	29.8%
Other Punctuation	434	14.3%

Most frequent character per category

Value	Count	Frequency (%)
0	581	34.2%
9	209	12.3%
4	205	12.1%
5	182	10.7%
2	167	9.8%
8	150	8.8%
3	116	6.8%
1	45	2.7%
7	22	1.3%
6	21	1.2%

Value	Count	Frequency (%)
f	475	52.4%
d	220	24.3%
e	78	8.6%
b	71	7.8%
c	57	6.3%
a	5	0.6%

Value	Count	Frequency (%)
#	434	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2132	70.2%
Latin	906	29.8%

Most frequent character per script

Value	Count	Frequency (%)
0	581	27.3%
#	434	20.4%
9	209	9.8%
4	205	9.6%
5	182	8.5%
2	167	7.8%
8	150	7.0%
3	116	5.4%
1	45	2.1%
7	22	1.0%

Value	Count	Frequency (%)
f	475	52.4%
d	220	24.3%
e	78	8.6%
b	71	7.8%
c	57	6.3%
a	5	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3038	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	581	19.1%
f	475	15.6%
#	434	14.3%
d	220	7.2%
9	209	6.9%
4	205	6.7%
5	182	6.0%
2	167	5.5%
8	150	4.9%
3	116	3.8%
Other values (7)	299	9.8%

id
Categorical

UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

ktspuh	1
kt6rch	1
ksfazj	1
krw60y	1
kt19l2	1
Other values (985)	985

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	5940
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	990 ?
Unique (%)	100.0%

Sample

1st row	kv4lr7
2nd row	kvg3xu
3rd row	kv4oca
4th row	kvekkt
5th row	kvfqwa

Value	Count	Frequency (%)
ktspuh	1	0.1%
kt6rch	1	0.1%
ksfazj	1	0.1%
krw60y	1	0.1%
kt19l2	1	0.1%
kuwiyo	1	0.1%
kqkswb	1	0.1%
kvekkt	1	0.1%
kr3bz7	1	0.1%
ku5mq9	1	0.1%
Other values (980)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
ktspuh	1	0.1%
kt6rch	1	0.1%
ksfazj	1	0.1%
krw60y	1	0.1%
kt19l2	1	0.1%
kuwiyo	1	0.1%
kqkswb	1	0.1%
kvekkt	1	0.1%
kr3bz7	1	0.1%
ku5mq9	1	0.1%
Other values (980)	980	99.0%

Most occurring characters

Value	Count	Frequency (%)
k	1097	18.5%
r	358	6.0%
s	349	5.9%
t	293	4.9%
u	252	4.2%
v	220	3.7%
q	168	2.8%
y	131	2.2%
z	130	2.2%
4	128	2.2%
Other values (26)	2814	47.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4861	81.8%
Decimal Number	1079	18.2%

Most frequent character per category

Value	Count	Frequency (%)
k	1097	22.6%
r	358	7.4%
s	349	7.2%
t	293	6.0%
u	252	5.2%
v	220	4.5%
q	168	3.5%
y	131	2.7%
z	130	2.7%
f	128	2.6%
Other values (16)	1735	35.7%

Value	Count	Frequency (%)
4	128	11.9%
5	117	10.8%
0	114	10.6%
8	112	10.4%
1	112	10.4%
7	110	10.2%
9	106	9.8%
3	100	9.3%
2	99	9.2%
6	81	7.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4861	81.8%
Common	1079	18.2%

Most frequent character per script

Value	Count	Frequency (%)
k	1097	22.6%
r	358	7.4%
s	349	7.2%
t	293	6.0%
u	252	5.2%
v	220	4.5%
q	168	3.5%
y	131	2.7%
z	130	2.7%
f	128	2.6%
Other values (16)	1735	35.7%

Value	Count	Frequency (%)
4	128	11.9%
5	117	10.8%
0	114	10.6%
8	112	10.4%
1	112	10.4%
7	110	10.2%
9	106	9.8%
3	100	9.3%
2	99	9.2%
6	81	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5940	100.0%

Most frequent character per block

Value	Count	Frequency (%)
k	1097	18.5%
r	358	6.0%
s	349	5.9%
t	293	4.9%
u	252	4.2%
v	220	3.7%
q	168	2.8%
y	131	2.2%
z	130	2.2%
4	128	2.2%
Other values (26)	2814	47.4%

is_robot_indexable
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

True	990

Common Values
Chart

Value	Count	Frequency (%)
True	990	100.0%

report_reasons
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

author
Categorical

HIGH CARDINALITY

Distinct	526
Distinct (%)	53.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

Wong_John	53
Phatbrew	48
DoremusJessup	27
progress18	21
BlankVerse	15
Other values (521)	826

Length

Max length	20
Median length	11
Mean length	11.34040404
Min length	4

Characters and Unicode

Total characters	11227
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	401 ?
Unique (%)	40.5%

Sample

1st row	progress18
2nd row	mahoneynikki
3rd row	Xfiles1987
4th row	Phatbrew
5th row	UploadedMind

Value	Count	Frequency (%)
Wong_John	53	5.4%
Phatbrew	48	4.8%
DoremusJessup	27	2.7%
progress18	21	2.1%
BlankVerse	15	1.5%
PopuleuxMusicYT	15	1.5%
Gonzo_B	15	1.5%
letstalkaboutit24	14	1.4%
1000000students	14	1.4%
epc2ky	14	1.4%
Other values (516)	754	76.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
wong_john	53	5.4%
phatbrew	48	4.8%
doremusjessup	27	2.7%
progress18	21	2.1%
populeuxmusicyt	15	1.5%
blankverse	15	1.5%
gonzo_b	15	1.5%
epc2ky	14	1.4%
letstalkaboutit24	14	1.4%
1000000students	14	1.4%
Other values (516)	754	76.2%

Most occurring characters

Value	Count	Frequency (%)
e	1040	9.3%
a	798	7.1%
o	688	6.1%
r	620	5.5%
n	580	5.2%
s	544	4.8%
t	527	4.7%
i	524	4.7%
l	489	4.4%
u	334	3.0%
Other values (56)	5083	45.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8757	78.0%
Uppercase Letter	1282	11.4%
Decimal Number	956	8.5%
Connector Punctuation	166	1.5%
Dash Punctuation	58	0.5%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
e	1040	11.9%
a	798	9.1%
o	688	7.9%
r	620	7.1%
n	580	6.6%
s	544	6.2%
t	527	6.0%
i	524	6.0%
l	489	5.6%
u	334	3.8%
Other values (16)	2613	29.8%

Value	Count	Frequency (%)
J	125	9.8%
P	101	7.9%
B	101	7.9%
D	94	7.3%
M	88	6.9%
W	81	6.3%
T	74	5.8%
A	68	5.3%
S	61	4.8%
E	51	4.0%
Other values (16)	438	34.2%

Value	Count	Frequency (%)
1	190	19.9%
0	181	18.9%
2	111	11.6%
9	97	10.1%
8	93	9.7%
7	72	7.5%
4	60	6.3%
5	58	6.1%
3	55	5.8%
6	39	4.1%

Value	Count	Frequency (%)
_	166	100.0%

Value	Count	Frequency (%)
-	58	100.0%

Value	Count	Frequency (%)
[	4	100.0%

Value	Count	Frequency (%)
]	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10039	89.4%
Common	1188	10.6%

Most frequent character per script

Value	Count	Frequency (%)
e	1040	10.4%
a	798	7.9%
o	688	6.9%
r	620	6.2%
n	580	5.8%
s	544	5.4%
t	527	5.2%
i	524	5.2%
l	489	4.9%
u	334	3.3%
Other values (42)	3895	38.8%

Value	Count	Frequency (%)
1	190	16.0%
0	181	15.2%
_	166	14.0%
2	111	9.3%
9	97	8.2%
8	93	7.8%
7	72	6.1%
4	60	5.1%
-	58	4.9%
5	58	4.9%
Other values (4)	102	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11227	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1040	9.3%
a	798	7.1%
o	688	6.1%
r	620	5.5%
n	580	5.2%
s	544	4.8%
t	527	4.7%
i	524	4.7%
l	489	4.4%
u	334	3.0%
Other values (56)	5083	45.3%

discussion_type
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	990
Missing (%)	100.0%
Memory size	7.9 KiB

num_comments
Real number (ℝ_≥0)

ZEROS

Distinct	81
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.32222222
Minimum	0
Maximum	628
Zeros	242
Zeros (%)	24.4%
Memory size	7.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	7
95-th percentile	40
Maximum	628
Range	628
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	40.43144732
Coefficient of variation (CV)	3.570981608
Kurtosis	109.0817444
Mean	11.32222222
Median Absolute Deviation (MAD)	2
Skewness	9.311684797
Sum	11209
Variance	1634.701932
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	242	24.4%
1	169	17.1%
2	107	10.8%
3	74	7.5%
4	49	4.9%
5	47	4.7%
6	30	3.0%
7	30	3.0%
9	24	2.4%
8	19	1.9%
Other values (71)	199	20.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	242	24.4%
1	169	17.1%
2	107	10.8%
3	74	7.5%
4	49	4.9%

Value	Count	Frequency (%)
628	1	0.1%
545	1	0.1%
408	1	0.1%
397	1	0.1%
316	1	0.1%

send_replies
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

True	922
False	68

Common Values
Chart

Value	Count	Frequency (%)
True	922	93.1%
False	68	6.9%

whitelist_status
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

all_ads	980
promo_adult_nsfw	10

Length

Max length	16
Median length	7
Mean length	7.090909091
Min length	7

Characters and Unicode

Total characters	7020
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	all_ads
2nd row	all_ads
3rd row	all_ads
4th row	all_ads
5th row	all_ads

Value	Count	Frequency (%)
all_ads	980	99.0%
promo_adult_nsfw	10	1.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
all_ads	980	99.0%
promo_adult_nsfw	10	1.0%

Most occurring characters

Value	Count	Frequency (%)
a	1970	28.1%
l	1970	28.1%
_	1000	14.2%
d	990	14.1%
s	990	14.1%
o	20	0.3%
p	10	0.1%
r	10	0.1%
m	10	0.1%
u	10	0.1%
Other values (4)	40	0.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6020	85.8%
Connector Punctuation	1000	14.2%

Most frequent character per category

Value	Count	Frequency (%)
a	1970	32.7%
l	1970	32.7%
d	990	16.4%
s	990	16.4%
o	20	0.3%
p	10	0.2%
r	10	0.2%
m	10	0.2%
u	10	0.2%
t	10	0.2%
Other values (3)	30	0.5%

Value	Count	Frequency (%)
_	1000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6020	85.8%
Common	1000	14.2%

Most frequent character per script

Value	Count	Frequency (%)
a	1970	32.7%
l	1970	32.7%
d	990	16.4%
s	990	16.4%
o	20	0.3%
p	10	0.2%
r	10	0.2%
m	10	0.2%
u	10	0.2%
t	10	0.2%
Other values (3)	30	0.5%

Value	Count	Frequency (%)
_	1000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7020	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	1970	28.1%
l	1970	28.1%
_	1000	14.2%
d	990	14.1%
s	990	14.1%
o	20	0.3%
p	10	0.1%
r	10	0.1%
m	10	0.1%
u	10	0.1%
Other values (4)	40	0.6%

contest_mode
Boolean

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	990

Common Values
Chart

Value	Count	Frequency (%)
False	990	100.0%

mod_reports
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

author_patreon_flair
Boolean

Distinct	1
Distinct (%)	0.1%
Missing	4
Missing (%)	0.4%
Memory size	7.7 KiB

False	986
(Missing)	4

Common Values
Chart

Value	Count	Frequency (%)
False	986	99.6%
(Missing)	4	0.4%

crosspost_parent
Categorical

MISSING
UNIFORM

Distinct	13
Distinct (%)	100.0%
Missing	977
Missing (%)	98.7%
Memory size	7.7 KiB

t3_krsf8c	1
t3_kqx151	1
t3_kqxf5o	1
t3_kuewpt	1
t3_krmvn9	1
Other values (8)	8

Length

Max length	9
Median length	3
Mean length	3.078787879
Min length	3

Characters and Unicode

Total characters	3048
Distinct characters	31
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13 ?
Unique (%)	100.0%

Sample

1st row	t3_kv4jen
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
t3_krsf8c	1	0.1%
t3_kqx151	1	0.1%
t3_kqxf5o	1	0.1%
t3_kuewpt	1	0.1%
t3_krmvn9	1	0.1%
t3_kt7y3r	1	0.1%
t3_ksgyrv	1	0.1%
t3_krxf5u	1	0.1%
t3_kqhqxu	1	0.1%
t3_kv4jen	1	0.1%
Other values (3)	3	0.3%
(Missing)	977	98.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	977	98.7%
t3_krsf8c	1	0.1%
t3_kqx151	1	0.1%
t3_kqxf5o	1	0.1%
t3_kuewpt	1	0.1%
t3_krmvn9	1	0.1%
t3_kt7y3r	1	0.1%
t3_ksgyrv	1	0.1%
t3_krxf5u	1	0.1%
t3_kqhqxu	1	0.1%
Other values (4)	4	0.4%

Most occurring characters

Value	Count	Frequency (%)
n	1956	64.2%
a	977	32.1%
t	16	0.5%
3	14	0.5%
_	13	0.4%
k	13	0.4%
r	6	0.2%
v	5	0.2%
f	4	0.1%
x	4	0.1%
Other values (21)	40	1.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3006	98.6%
Decimal Number	29	1.0%
Connector Punctuation	13	0.4%

Most frequent character per category

Value	Count	Frequency (%)
n	1956	65.1%
a	977	32.5%
t	16	0.5%
k	13	0.4%
r	6	0.2%
v	5	0.2%
f	4	0.1%
x	4	0.1%
q	4	0.1%
e	3	0.1%
Other values (12)	18	0.6%

Value	Count	Frequency (%)
3	14	48.3%
4	3	10.3%
1	3	10.3%
9	3	10.3%
5	3	10.3%
2	1	3.4%
7	1	3.4%
8	1	3.4%

Value	Count	Frequency (%)
_	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3006	98.6%
Common	42	1.4%

Most frequent character per script

Value	Count	Frequency (%)
n	1956	65.1%
a	977	32.5%
t	16	0.5%
k	13	0.4%
r	6	0.2%
v	5	0.2%
f	4	0.1%
x	4	0.1%
q	4	0.1%
e	3	0.1%
Other values (12)	18	0.6%

Value	Count	Frequency (%)
3	14	33.3%
_	13	31.0%
4	3	7.1%
1	3	7.1%
9	3	7.1%
5	3	7.1%
2	1	2.4%
7	1	2.4%
8	1	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3048	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1956	64.2%
a	977	32.1%
t	16	0.5%
3	14	0.5%
_	13	0.4%
k	13	0.4%
r	6	0.2%
v	5	0.2%
f	4	0.1%
x	4	0.1%
Other values (21)	40	1.3%

author_flair_text_color
Categorical

MISSING

Distinct	1
Distinct (%)	10.0%
Missing	980
Missing (%)	99.0%
Memory size	7.7 KiB

dark	10

Length

Max length	4
Median length	3
Mean length	3.01010101
Min length	3

Characters and Unicode

Total characters	2980
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	nan
5th row	nan

Value	Count	Frequency (%)
dark	10	1.0%
(Missing)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	980	99.0%
dark	10	1.0%

Most occurring characters

Value	Count	Frequency (%)
n	1960	65.8%
a	990	33.2%
d	10	0.3%
r	10	0.3%
k	10	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2980	100.0%

Most frequent character per category

Value	Count	Frequency (%)
n	1960	65.8%
a	990	33.2%
d	10	0.3%
r	10	0.3%
k	10	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2980	100.0%

Most frequent character per script

Value	Count	Frequency (%)
n	1960	65.8%
a	990	33.2%
d	10	0.3%
r	10	0.3%
k	10	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2980	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	1960	65.8%
a	990	33.2%
d	10	0.3%
r	10	0.3%
k	10	0.3%

permalink
Path

UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

/r/democrats/comments/kub5f0/follow_me/	1
/r/democrats/comments/ktxl87/biden_assembling_multitrilliondollar_stimulus/	1
/r/democrats/comments/kq1wdm/impeachable_offence_aoc_wants_to_sanction_trump/	1
/r/democrats/comments/kqy084/trump_just_fcked_himself_and_his_party_in_georgia/	1
/r/democrats/comments/kr2x00/trump_not_allowed_into_scotland_to_escape_biden/	1
Other values (985)	985

Length

Max length	80
Median length	74
Mean length	67.42929293
Min length	31

Characters and Unicode

Total characters	66755
Distinct characters	38
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	990 ?
Unique (%)	100.0%

Sample

1st row	/r/democrats/comments/kv4lr7/house_democrats_launch_second_impeachment_of/
2nd row	/r/democrats/comments/kvg3xu/do_i_have_to/
3rd row	/r/democrats/comments/kv4oca/camp_auschwitz_guy_identified/
4th row	/r/democrats/comments/kvekkt/no_crawling_back/
5th row	/r/democrats/comments/kvfqwa/use_the_14th_amendment_to_ban_trump/

Value	Count	Frequency (%)
/r/democrats/comments/kub5f0/follow_me/	1	0.1%
/r/democrats/comments/ktxl87/biden_assembling_multitrilliondollar_stimulus/	1	0.1%
/r/democrats/comments/kq1wdm/impeachable_offence_aoc_wants_to_sanction_trump/	1	0.1%
/r/democrats/comments/kqy084/trump_just_fcked_himself_and_his_party_in_georgia/	1	0.1%
/r/democrats/comments/kr2x00/trump_not_allowed_into_scotland_to_escape_biden/	1	0.1%
/r/democrats/comments/ktbpbk/democratic_attorneys_general_accuse_gop/	1	0.1%
/r/democrats/comments/kvm1bz/three_new_terrifying_plots_to_overthrow_government/	1	0.1%
/r/democrats/comments/kt5u9x/how_the_us_capitol_police_were_overrun_in_a/	1	0.1%
/r/democrats/comments/krolbz/how_georgia_changes_everything_for_joe_biden_and/	1	0.1%
/r/democrats/comments/krgs5l/jon_ossoff_wins/	1	0.1%
Other values (980)	980	99.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
r/democrats/comments/krxf8x/biden_condemns_riots_at_capitol_calls_on_trump_to	1	0.1%
r/democrats/comments/ktjb4f/alex_jones_says_he_paid_500000_for_rally_that_led	1	0.1%
r/democrats/comments/krxwmh/i_guess_this_aged_like_milk	1	0.1%
r/democrats/comments/kqrcq8/don_winslow_films_countryovertrump	1	0.1%
r/democrats/comments/kt5bi2/is_it_possible_to_overdose_on_schadenfreude	1	0.1%
r/democrats/comments/kuhooy/twitter_congress	1	0.1%
r/democrats/comments/kudve2/impeach_donald_trump_oc	1	0.1%
r/democrats/comments/krcryy/ga_voters_that_split_your_ticket_why	1	0.1%
r/democrats/comments/kti8mc/01062021	1	0.1%
r/democrats/comments/ktbpbk/democratic_attorneys_general_accuse_gop	1	0.1%
Other values (980)	980	99.0%

Most occurring characters

Value	Count	Frequency (%)
/	5940	8.9%
e	5591	8.4%
_	5522	8.3%
t	5125	7.7%
o	4590	6.9%
s	4520	6.8%
r	4500	6.7%
m	4099	6.1%
a	3509	5.3%
c	3162	4.7%
Other values (28)	20197	30.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	54017	80.9%
Other Punctuation	5940	8.9%
Connector Punctuation	5522	8.3%
Decimal Number	1276	1.9%

Most frequent character per category

Value	Count	Frequency (%)
e	5591	10.4%
t	5125	9.5%
o	4590	8.5%
s	4520	8.4%
r	4500	8.3%
m	4099	7.6%
a	3509	6.5%
c	3162	5.9%
n	3073	5.7%
i	2370	4.4%
Other values (16)	13478	25.0%

Value	Count	Frequency (%)
0	185	14.5%
1	148	11.6%
4	138	10.8%
2	138	10.8%
5	130	10.2%
7	115	9.0%
9	115	9.0%
8	114	8.9%
3	105	8.2%
6	88	6.9%

Value	Count	Frequency (%)
/	5940	100.0%

Value	Count	Frequency (%)
_	5522	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	54017	80.9%
Common	12738	19.1%

Most frequent character per script

Value	Count	Frequency (%)
e	5591	10.4%
t	5125	9.5%
o	4590	8.5%
s	4520	8.4%
r	4500	8.3%
m	4099	7.6%
a	3509	6.5%
c	3162	5.9%
n	3073	5.7%
i	2370	4.4%
Other values (16)	13478	25.0%

Value	Count	Frequency (%)
/	5940	46.6%
_	5522	43.4%
0	185	1.5%
1	148	1.2%
4	138	1.1%
2	138	1.1%
5	130	1.0%
7	115	0.9%
9	115	0.9%
8	114	0.9%
Other values (2)	193	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66755	100.0%

Most frequent character per block

Value	Count	Frequency (%)
/	5940	8.9%
e	5591	8.4%
_	5522	8.3%
t	5125	7.7%
o	4590	6.9%
s	4520	6.8%
r	4500	6.7%
m	4099	6.1%
a	3509	5.3%
c	3162	4.7%
Other values (28)	20197	30.3%

Common prefix	\r\democrats\comments\k
Unique stems	981
Unique names	981
Unique extensions	1
Unique directories	990
Unique anchors	1

Value	Count	Frequency (%)
/r/democrats/comments/kub5f0/follow_me/	1	0.1%
/r/democrats/comments/ktxl87/biden_assembling_multitrilliondollar_stimulus/	1	0.1%
/r/democrats/comments/kq1wdm/impeachable_offence_aoc_wants_to_sanction_trump/	1	0.1%
/r/democrats/comments/kqy084/trump_just_fcked_himself_and_his_party_in_georgia/	1	0.1%
/r/democrats/comments/kr2x00/trump_not_allowed_into_scotland_to_escape_biden/	1	0.1%
/r/democrats/comments/ktbpbk/democratic_attorneys_general_accuse_gop/	1	0.1%
/r/democrats/comments/kvm1bz/three_new_terrifying_plots_to_overthrow_government/	1	0.1%
/r/democrats/comments/kt5u9x/how_the_us_capitol_police_were_overrun_in_a/	1	0.1%
/r/democrats/comments/krolbz/how_georgia_changes_everything_for_joe_biden_and/	1	0.1%
/r/democrats/comments/krgs5l/jon_ossoff_wins/	1	0.1%
Other values (980)	980	99.0%

Value	Count	Frequency (%)
_	3	0.3%
mustsee_new_video_shows_capitol_riot_was_way	2	0.2%
we_did_it	2	0.2%
gop_senator_says_trump_committed_impeachable	2	0.2%
moscow_mitch_is_now_minority_mitch	2	0.2%
another_reason_why_we_need_dc_statehood	2	0.2%
this	2	0.2%
the_147_republicans_who_voted_to_overturn	2	0.2%
and_the_winner_is	1	0.1%
its_this_then	1	0.1%
Other values (971)	971	98.1%

Value	Count	Frequency (%)
_	3	0.3%
mustsee_new_video_shows_capitol_riot_was_way	2	0.2%
we_did_it	2	0.2%
gop_senator_says_trump_committed_impeachable	2	0.2%
moscow_mitch_is_now_minority_mitch	2	0.2%
another_reason_why_we_need_dc_statehood	2	0.2%
this	2	0.2%
the_147_republicans_who_voted_to_overturn	2	0.2%
and_the_winner_is	1	0.1%
its_this_then	1	0.1%
Other values (971)	971	98.1%

Value	Count	Frequency (%)
	990	100.0%

Value	Count	Frequency (%)
\r\democrats\comments\kqrcq8	1	0.1%
\r\democrats\comments\kskp12	1	0.1%
\r\democrats\comments\krwlyd	1	0.1%
\r\democrats\comments\ks2ctb	1	0.1%
\r\democrats\comments\kujpfh	1	0.1%
\r\democrats\comments\ks1zwr	1	0.1%
\r\democrats\comments\ksavgc	1	0.1%
\r\democrats\comments\kryy9a	1	0.1%
\r\democrats\comments\krj3f1	1	0.1%
\r\democrats\comments\krdygy	1	0.1%
Other values (980)	980	99.0%

Value	Count	Frequency (%)
\	990	100.0%

parent_whitelist_status
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

all_ads	990

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	6930
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	all_ads
2nd row	all_ads
3rd row	all_ads
4th row	all_ads
5th row	all_ads

Value	Count	Frequency (%)
all_ads	990	100.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
all_ads	990	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	1980	28.6%
l	1980	28.6%
_	990	14.3%
d	990	14.3%
s	990	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5940	85.7%
Connector Punctuation	990	14.3%

Most frequent character per category

Value	Count	Frequency (%)
a	1980	33.3%
l	1980	33.3%
d	990	16.7%
s	990	16.7%

Value	Count	Frequency (%)
_	990	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5940	85.7%
Common	990	14.3%

Most frequent character per script

Value	Count	Frequency (%)
a	1980	33.3%
l	1980	33.3%
d	990	16.7%
s	990	16.7%

Value	Count	Frequency (%)
_	990	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6930	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	1980	28.6%
l	1980	28.6%
_	990	14.3%
d	990	14.3%
s	990	14.3%

stickied
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	989
True	1

Common Values
Chart

Value	Count	Frequency (%)
False	989	99.9%
True	1	0.1%

url
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	986
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

https://www.bbc.co.uk/news/technology-55569604	2
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2
https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576/	2
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2
https://i.redd.it/sq6ala7y27a61.jpg	1
Other values (981)	981

Length

Max length	341
Median length	35
Mean length	64.63636364
Min length	22

Characters and Unicode

Total characters	63990
Distinct characters	73
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	982 ?
Unique (%)	99.2%

Sample

1st row	/r/JoeBiden/comments/kv4jen/house_democrats_launch_second_impeachment_of/
2nd row	https://i.redd.it/sq8b597wpsa61.jpg
3rd row	https://i.redd.it/ewmxi3oh0qa61.jpg
4th row	https://i.redd.it/863qmtjcbsa61.jpg
5th row	https://i.redd.it/nil93j0cmsa61.jpg

Value	Count	Frequency (%)
https://www.bbc.co.uk/news/technology-55569604	2	0.2%
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2	0.2%
https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576/	2	0.2%
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2	0.2%
https://i.redd.it/sq6ala7y27a61.jpg	1	0.1%
https://i.redd.it/webvfod2bx961.png	1	0.1%
https://np.reddit.com/r/democrats/comments/ksd6uf/congrats_to_georgias_two_new_democratic_senators/?utm_source=share&utm_medium=ios_app&utm_name=iossmf	1	0.1%
https://www.reddit.com/r/democrats/comments/ks0d4b/small_self_post_its_important_to_realize_that/	1	0.1%
https://www.huffpost.com/entry/joe-biden-democrats-verge-of-trifecta_n_5ff55a33c5b665581f667eea	1	0.1%
https://i.redd.it/bc2c328z9t961.jpg	1	0.1%
Other values (976)	976	98.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
https://www.cnn.com/2021/01/07/politics/trump-biden-us-capitol-electoral-college-insurrection/index.html	2	0.2%
https://www.theatlantic.com/ideas/archive/2021/01/remove-trump-tonight/617576	2	0.2%
https://www.bbc.co.uk/news/technology-55569604	2	0.2%
https://www.nytimes.com/interactive/2021/01/07/us/elections/electoral-college-biden-objectors.html	2	0.2%
https://i.redd.it/m5280k0azj961.jpg	1	0.1%
https://i.redd.it/c89eyzdb80a61.png	1	0.1%
https://youtu.be/9k49327u4xm	1	0.1%
https://www.houstonchronicle.com/opinion/editorials/article/editorial-resign-senator-cruz-your-lies-cost-15857293.php	1	0.1%
https://v.redd.it/mtujnab93ia61	1	0.1%
https://i.redd.it/gatkitroem961.jpg	1	0.1%
Other values (976)	976	98.6%

Most occurring characters

Value	Count	Frequency (%)
t	5287	8.3%
/	4396	6.9%
e	3732	5.8%
s	3269	5.1%
i	3186	5.0%
o	2829	4.4%
-	2681	4.2%
r	2655	4.1%
a	2526	3.9%
p	2525	3.9%
Other values (63)	30904	48.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45667	71.4%
Other Punctuation	7928	12.4%
Decimal Number	6374	10.0%
Dash Punctuation	2681	4.2%
Uppercase Letter	668	1.0%
Connector Punctuation	574	0.9%
Math Symbol	98	0.2%

Most frequent character per category

Value	Count	Frequency (%)
t	5287	11.6%
e	3732	8.2%
s	3269	7.2%
i	3186	7.0%
o	2829	6.2%
r	2655	5.8%
a	2526	5.5%
p	2525	5.5%
n	2169	4.7%
d	2108	4.6%
Other values (16)	15381	33.7%

Value	Count	Frequency (%)
S	43	6.4%
C	42	6.3%
B	40	6.0%
U	35	5.2%
P	32	4.8%
R	32	4.8%
F	32	4.8%
I	31	4.6%
T	29	4.3%
H	28	4.2%
Other values (16)	324	48.5%

Value	Count	Frequency (%)
1	1260	19.8%
6	874	13.7%
0	783	12.3%
2	733	11.5%
9	596	9.4%
5	487	7.6%
3	439	6.9%
4	423	6.6%
7	395	6.2%
8	384	6.0%

Value	Count	Frequency (%)
/	4396	55.4%
.	2385	30.1%
:	987	12.4%
?	73	0.9%
%	32	0.4%
&	26	0.3%
;	26	0.3%
#	3	< 0.1%

Value	Count	Frequency (%)
_	574	100.0%

Value	Count	Frequency (%)
-	2681	100.0%

Value	Count	Frequency (%)
=	98	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46335	72.4%
Common	17655	27.6%

Most frequent character per script

Value	Count	Frequency (%)
t	5287	11.4%
e	3732	8.1%
s	3269	7.1%
i	3186	6.9%
o	2829	6.1%
r	2655	5.7%
a	2526	5.5%
p	2525	5.4%
n	2169	4.7%
d	2108	4.5%
Other values (42)	16049	34.6%

Value	Count	Frequency (%)
/	4396	24.9%
-	2681	15.2%
.	2385	13.5%
1	1260	7.1%
:	987	5.6%
6	874	5.0%
0	783	4.4%
2	733	4.2%
9	596	3.4%
_	574	3.3%
Other values (11)	2386	13.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	63990	100.0%

Most frequent character per block

Value	Count	Frequency (%)
t	5287	8.3%
/	4396	6.9%
e	3732	5.8%
s	3269	5.1%
i	3186	5.0%
o	2829	4.4%
-	2681	4.2%
r	2655	4.1%
a	2526	3.9%
p	2525	3.9%
Other values (63)	30904	48.3%

subreddit_subscribers
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	7.7 KiB

175116	418
175113	224
175115	199
175114	149

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	5940
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	175113
2nd row	175113
3rd row	175113
4th row	175113
5th row	175113

Value	Count	Frequency (%)
175116	418	42.2%
175113	224	22.6%
175115	199	20.1%
175114	149	15.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
175116	418	42.2%
175113	224	22.6%
175115	199	20.1%
175114	149	15.1%

Most occurring characters

Value	Count	Frequency (%)
1	2970	50.0%
5	1189	20.0%
7	990	16.7%
6	418	7.0%
3	224	3.8%
4	149	2.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5940	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	2970	50.0%
5	1189	20.0%
7	990	16.7%
6	418	7.0%
3	224	3.8%
4	149	2.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	5940	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	2970	50.0%
5	1189	20.0%
7	990	16.7%
6	418	7.0%
3	224	3.8%
4	149	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5940	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	2970	50.0%
5	1189	20.0%
7	990	16.7%
6	418	7.0%
3	224	3.8%
4	149	2.5%

created_utc
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	990
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1610089443
Minimum	1609685644
Maximum	1610433389
Zeros	0
Zeros (%)	0.0%
Memory size	7.7 KiB

Quantile statistics

Minimum	1609685644
5-th percentile	1609815188
Q1	1609964529
median	1610059343
Q3	1610223065
95-th percentile	1610401803
Maximum	1610433389
Range	747745
Interquartile range (IQR)	258535.75

Descriptive statistics

Standard deviation	173770.9156
Coefficient of variation (CV)	0.00010792625
Kurtosis	-0.8019262211
Mean	1610089443
Median Absolute Deviation (MAD)	108261.5
Skewness	0.2728621604
Sum	1.593988548 × 10¹²
Variance	3.019633112 × 10¹⁰
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1609958627	1	0.1%
1609950020	1	0.1%
1610377908	1	0.1%
1610066190	1	0.1%
1609907247	1	0.1%
1609957096	1	0.1%
1610427833	1	0.1%
1610382386	1	0.1%
1610160501	1	0.1%
1609947936	1	0.1%
Other values (980)	980	99.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1609685644	1	0.1%
1609707433	1	0.1%
1609724158	1	0.1%
1609725465	1	0.1%
1609734414	1	0.1%

Value	Count	Frequency (%)
1610433389	1	0.1%
1610432179	1	0.1%
1610432021	1	0.1%
1610431743	1	0.1%
1610431044	1	0.1%

num_crossposts
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09191919192
Minimum	0
Maximum	7
Zeros	943
Zeros (%)	95.3%
Memory size	7.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5364710303
Coefficient of variation (CV)	5.836333187
Kurtosis	74.29531754
Mean	0.09191919192
Median Absolute Deviation (MAD)	0
Skewness	8.06968731
Sum	91
Variance	0.2878011664
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	943	95.3%
1	31	3.1%
5	6	0.6%
2	5	0.5%
3	3	0.3%
7	1	0.1%
4	1	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	943	95.3%
1	31	3.1%
2	5	0.5%
3	3	0.3%
4	1	0.1%

Value	Count	Frequency (%)
7	1	0.1%
5	6	0.6%
4	1	0.1%
3	3	0.3%
2	5	0.5%

media
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	883
Missing (%)	89.2%
Memory size	7.9 KiB

is_video
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	990.0 B

False	987
True	3

Common Values
Chart

Value	Count	Frequency (%)
False	987	99.7%
True	3	0.3%

author_cakeday
Boolean

MISSING

Distinct	1
Distinct (%)	50.0%
Missing	988
Missing (%)	99.8%
Memory size	7.7 KiB

True	2
(Missing)	988

Common Values
Chart

Value	Count	Frequency (%)
True	2	0.2%
(Missing)	988	99.8%

is_gallery
Boolean

MISSING

Distinct	1
Distinct (%)	16.7%
Missing	984
Missing (%)	99.4%
Memory size	7.7 KiB

True	6
(Missing)	984

Common Values
Chart

Value	Count	Frequency (%)
True	6	0.6%
(Missing)	984	99.4%

media_metadata
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	983
Missing (%)	99.3%
Memory size	7.9 KiB

gallery_data
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	984
Missing (%)	99.4%
Memory size	7.9 KiB

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

First rows

	approved_at_utc	subreddit	author_fullname	saved	mod_reason_title	gilded	clicked	title	link_flair_richtext	subreddit_name_prefixed	hidden	pwls	link_flair_css_class	thumbnail_height	top_awarded_type	hide_score	name	quarantine	link_flair_text_color	upvote_ratio	author_flair_background_color	subreddit_type	ups	total_awards_received	media_embed	thumbnail_width	author_flair_template_id	is_original_content	user_reports	secure_media	is_reddit_media_domain	is_meta	category	secure_media_embed	link_flair_text	can_mod_post	score	approved_by	author_premium	thumbnail	edited	author_flair_css_class	author_flair_richtext	gildings	post_hint	content_categories	is_self	mod_note	crosspost_parent_list	created	link_flair_type	wls	removed_by_category	banned_by	author_flair_type	domain	allow_live_comments	selftext_html	likes	suggested_sort	banned_at_utc	url_overridden_by_dest	view_count	archived	no_follow	is_crosspostable	pinned	over_18	preview	all_awardings	awarders	media_only	link_flair_template_id	can_gild	spoiler	locked	author_flair_text	treatment_tags	visited	removed_by	num_reports	distinguished	subreddit_id	mod_reason_by	removal_reason	link_flair_background_color	id	is_robot_indexable	report_reasons	author	discussion_type	num_comments	send_replies	whitelist_status	contest_mode	mod_reports	author_patreon_flair	crosspost_parent	author_flair_text_color	permalink	parent_whitelist_status	stickied	url	subreddit_subscribers	created_utc	num_crossposts	media	is_video	author_cakeday	is_gallery	media_metadata	gallery_data
0	None	democrats	t2_nkk56	False	None	0	False	House Democrats launch second impeachment of Trump for his role in last week's deadly Capitol attack	[{'e': 'text', 't': '🔴 Megathread'}]	r/democrats	False	6		NaN	None	False	t3_kv4lr7	False	dark	0.92	None	public	67	0	{}	NaN	None	False	[]	None	False	False	None	{}	🔴 Megathread	False	67	None	True	default	False	None	[]	{}	link	None	False	None	[{'approved_at_utc': None, 'subreddit': 'JoeBiden', 'selftext': 'The House Article of Impeachment will be introduced at 11 a.m. ET today. U.S. House Representatives David Ciciline (D-RI), Ted Lieu (D-CA), and Jamie Raskin (D-MD) are the co-sponsors of the article. #Take action: [Join us to discuss the second impeachment on Discord](https://discord.gg/ZHaCQ8VFvA). House Democrats will charge Trump with "inclement of insurrection" for his role in last week’s deadly Capitol attack. A draft of the resolution states: > ARTICLE 1: INCITEMENT OF INSURRECTION > ...In his conduct of the President of the United States—and in violation of his constitutional oath faithfully to execute the offie of President of the United States and, to the best of his ability, preserve, protect, and defend the Constitution of the United States, and in violation of his constitutional duty to take care that the laws be faithfully executed—Donald John Trump engaged in high Crimes and Misdemeanors by willfully inciting violence against the Government of the United States… Live Updates * CNN: [Live updates](https://www.cnn.com/politics/live-news/trump-impeachment-news-01-11-21/index.html) Live Streams * [NBC News NOW](https://www.youtube.com/watch?v=BVqm9JnKHZM) * [ABC News Live](https://www.youtube.com/watch?v=w_Ma8oQLmSM) * [C-SPAN](https://www.c-span.org/video/?507803-1/house-expected-introduce-article-impeachment-president-trump) * [PBS NewsHour](https://www.youtube.com/watch?v=i35nRKxOtVQ&) * More live streams will be added in this section once they go live Use the report button to report any trolls.', 'author_fullname': 't2_nkk56', 'saved': False, 'mod_reason_title': None, 'gilded': 0, 'clicked': False, 'title': 'House Democrats launch second impeachment of Trump for his role in last week’s deadly Capitol attack', 'link_flair_richtext': [{'e': 'text', 't': '🔴 Megathread'}], 'subreddit_name_prefixed': 'r/JoeBiden', 'hidden': False, 'pwls': 7, 'link_flair_css_class': '', 'downs': 0, 'thumbnail_height': None, 'top_awarded_type': None, 'hide_score': False, 'name': 't3_kv4jen', 'quarantine': False, 'link_flair_text_color': 'dark', 'upvote_ratio': 0.98, 'author_flair_background_color': '', 'subreddit_type': 'public', 'ups': 203, 'total_awards_received': 0, 'media_embed': {}, 'thumbnail_width': None, 'author_flair_template_id': None, 'is_original_content': False, 'user_reports': [], 'secure_media': None, 'is_reddit_media_domain': False, 'is_meta': False, 'category': None, 'secure_media_embed': {}, 'link_flair_text': '🔴 Megathread', 'can_mod_post': False, 'score': 203, 'approved_by': None, 'author_premium': True, 'thumbnail': 'self', 'edited': 1610382383.0, 'author_flair_css_class': '', 'author_flair_richtext': [], 'gildings': {}, 'post_hint': 'self', 'content_categories': None, 'is_self': True, 'mod_note': None, 'created': 1610406838.0, 'link_flair_type': 'richtext', 'wls': 7, 'removed_by_category': None, 'banned_by': None, 'author_flair_type': 'text', 'domain': 'self.JoeBiden', 'allow_live_comments': True, 'selftext_html': '<!-- SC_OFF --><div class="md"><p>The House Article of Impeachment will be introduced at 11 a.m. ET today. </p> <p>U.S. House Representatives David Ciciline (D-RI), Ted Lieu (D-CA), and Jamie Raskin (D-MD) are the co-sponsors of the article.</p> <h1>Take action: <strong><a href="https://discord.gg/ZHaCQ8VFvA">Join us to discuss the second impeachment on Discord</a></strong>.</h1> <p>House Democrats will charge Trump with &quot;inclement of insurrection&quot; for his role in last week’s deadly Capitol attack.</p> <p>A draft of the resolution states: </p> <blockquote> <p><strong>ARTICLE 1: INCITEMENT OF INSURRECTION</strong></p> <p>...In his conduct of the President of the United States—and in violation of his constitutional oath faithfully to execute the offie of President of the United States and, to the best of his ability, preserve, protect, and defend the Constitution of the United States, and in violation of his constitutional duty to take care that the laws be faithfully executed—Donald John Trump engaged in high Crimes and Misdemeanors by willfully inciting violence against the Government of the United States…</p> </blockquote> <p><strong>Live Updates</strong></p> <ul> <li>CNN: <a href="https://www.cnn.com/politics/live-news/trump-impeachment-news-01-11-21/index.html">Live updates</a></li> </ul> <p><strong>Live Streams</strong></p> <ul> <li><a href="https://www.youtube.com/watch?v=BVqm9JnKHZM">NBC News NOW</a></li> <li><a href="https://www.youtube.com/watch?v=w_Ma8oQLmSM">ABC News Live</a></li> <li><a href="https://www.c-span.org/video/?507803-1/house-expected-introduce-article-impeachment-president-trump">C-SPAN</a></li> <li><a href="https://www.youtube.com/watch?v=i35nRKxOtVQ&amp;">PBS NewsHour</a></li> <li><em>More live streams will be added in this section once they go live</em></li> </ul> <p><em>Use the report button to report any trolls.</em></p> </div><!-- SC_ON -->', 'likes': None, 'suggested_sort': 'new', 'banned_at_utc': None, 'view_count': None, 'archived': False, 'no_follow': False, 'is_crosspostable': False, 'pinned': False, 'over_18': False, 'preview': {'images': [{'source': {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?auto=webp&s=f691417fc434d08017454d1d9308ed4598a2206e', 'width': 512, 'height': 287}, 'resolutions': [{'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=108&crop=smart&auto=webp&s=66e36eecf1238fa4b7c58de379031cd7ea1757b2', 'width': 108, 'height': 60}, {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=216&crop=smart&auto=webp&s=afa7264f89679bd7febcdafcc6b14897c977ed80', 'width': 216, 'height': 121}, {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=320&crop=smart&auto=webp&s=31ff35d7cb50f3de6103ada04cf7678d642796a1', 'width': 320, 'height': 179}], 'variants': {}, 'id': 'ec0Lg2SSTfaJYOl5KIh7UjZSS3w34srrrVtKIPb-wB0'}], 'enabled': False}, 'all_awardings': [], 'awarders': [], 'media_only': False, 'link_flair_template_id': 'f07f007a-2085-11eb-936e-0eaf51d33c6f', 'can_gild': False, 'spoiler': False, 'locked': False, 'author_flair_text': '', 'treatment_tags': [], 'visited': False, 'removed_by': None, 'num_reports': None, 'distinguished': 'moderator', 'subreddit_id': 't5_2t0th', 'mod_reason_by': None, 'removal_reason': None, 'link_flair_background_color': '#ffffff', 'id': 'kv4jen', 'is_robot_indexable': True, 'report_reasons': None, 'author': 'progress18', 'discussion_type': None, 'num_comments': 51, 'send_replies': False, 'whitelist_status': 'some_ads', 'contest_mode': False, 'mod_reports': [], 'author_patreon_flair': False, 'author_flair_text_color': '', 'permalink': '/r/JoeBiden/comments/kv4jen/house_democrats_launch_second_impeachment_of/', 'parent_whitelist_status': 'some_ads', ...}]	1.610407e+09	richtext	6	None	None	text	self.JoeBiden	False	None	None	new	None	/r/JoeBiden/comments/kv4jen/house_democrats_launch_second_impeachment_of/	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?auto=webp&s=f691417fc434d08017454d1d9308ed4598a2206e', 'width': 512, 'height': 287}, 'resolutions': [{'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=108&crop=smart&auto=webp&s=66e36eecf1238fa4b7c58de379031cd7ea1757b2', 'width': 108, 'height': 60}, {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=216&crop=smart&auto=webp&s=afa7264f89679bd7febcdafcc6b14897c977ed80', 'width': 216, 'height': 121}, {'url': 'https://external-preview.redd.it/59twj7bSjJbvxA77N3cjpMnfcuStuw_HncWcx2a_WXY.jpg?width=320&crop=smart&auto=webp&s=31ff35d7cb50f3de6103ada04cf7678d642796a1', 'width': 320, 'height': 179}], 'variants': {}, 'id': 'ec0Lg2SSTfaJYOl5KIh7UjZSS3w34srrrVtKIPb-wB0'}], 'enabled': False}	[]	[]	False	67d78188-5420-11eb-8a07-0e0fd072bff5	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ffffff	kv4lr7	True	None	progress18	None	7	False	all_ads	False	[]	False	t3_kv4jen	None	/r/democrats/comments/kv4lr7/house_democrats_launch_second_impeachment_of/	all_ads	True	/r/JoeBiden/comments/kv4jen/house_democrats_launch_second_impeachment_of/	175113	1.610378e+09	0	None	False	NaN	NaN	NaN	NaN
1	None	democrats	t2_4f8e5viq	False	None	0	False	Do I have to?	[]	r/democrats	False	6	None	93.0	None	False	t3_kvg3xu	False	dark	0.97	None	public	2153	1	{}	140.0	None	False	[]	None	True	False	None	{}	None	False	2153	None	False	https://b.thumbs.redditmedia.com/M36F25Qpk1BhfFggn_BTDeKt1uBhlc1PPDUjpbGUGSg.jpg	False	None	[]	{'gid_1': 1}	image	None	False	None	NaN	1.610440e+09	text	6	None	None	text	i.redd.it	True	None	None	None	None	https://i.redd.it/sq8b597wpsa61.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?auto=webp&s=e259d58611539d63ee5286de97a896547dfcc1cc', 'width': 1284, 'height': 856}, 'resolutions': [{'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=108&crop=smart&auto=webp&s=2eff6d781bf01995678be89e50f52d88e0171c2f', 'width': 108, 'height': 72}, {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=216&crop=smart&auto=webp&s=b979fdd7fc9e62e39bf55a39d8dcab3be48c9ea1', 'width': 216, 'height': 144}, {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=320&crop=smart&auto=webp&s=772af78b5def3ed507b2029742a92a0bb3933c95', 'width': 320, 'height': 213}, {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=640&crop=smart&auto=webp&s=6c4250338bc8a274d1364f735f674a84ba99bb1e', 'width': 640, 'height': 426}, {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=960&crop=smart&auto=webp&s=9ca08432c5d267168fd42e5969e80ded9b11497d', 'width': 960, 'height': 640}, {'url': 'https://preview.redd.it/sq8b597wpsa61.jpg?width=1080&crop=smart&auto=webp&s=8dbb5307e164841a38eed2ba4615ecc27a4754c6', 'width': 1080, 'height': 720}], 'variants': {}, 'id': 'BxYUVj3Y1rZw6umy28MxfX1ULDcn9Ohou_miTcFszfQ'}], 'enabled': True}	[{'giver_coin_reward': None, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 100, 'id': 'gid_1', 'penny_donate': None, 'award_sub_type': 'GLOBAL', 'coin_reward': 0, 'icon_url': 'https://www.redditstatic.com/gold/awards/icon/silver_512.png', 'days_of_premium': 0, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/silver_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_128.png', 'width': 128, 'height': 128}], 'icon_width': 512, 'static_icon_width': 512, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'Shows the Silver Award... and that's it.', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 512, 'name': 'Silver', 'resized_static_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/silver_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_128.png', 'width': 128, 'height': 128}], 'icon_format': None, 'icon_height': 512, 'penny_price': None, 'award_type': 'global', 'static_icon_url': 'https://www.redditstatic.com/gold/awards/icon/silver_512.png'}]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kvg3xu	True	None	mahoneynikki	None	55	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvg3xu/do_i_have_to/	all_ads	False	https://i.redd.it/sq8b597wpsa61.jpg	175113	1.610411e+09	1	None	False	NaN	NaN	NaN	NaN
2	None	democrats	t2_17c1os	False	None	0	False	"Camp Auschwitz" guy identified!	[]	r/democrats	False	6	None	140.0	None	False	t3_kv4oca	False	dark	0.98	None	public	1973	0	{}	140.0	None	False	[]	None	True	False	None	{}	None	False	1973	None	False	https://b.thumbs.redditmedia.com/zV6srycz20pOs5oTC-OJA8ZB775smAhjKA37Z92diAg.jpg	False	None	[]	{}	image	None	False	None	NaN	1.610407e+09	text	6	None	None	text	i.redd.it	True	None	None	None	None	https://i.redd.it/ewmxi3oh0qa61.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/ewmxi3oh0qa61.jpg?auto=webp&s=bc4e227a4368e81672dacf3e30e7d9a7450014fb', 'width': 720, 'height': 1560}, 'resolutions': [{'url': 'https://preview.redd.it/ewmxi3oh0qa61.jpg?width=108&crop=smart&auto=webp&s=e0d9362263469d0582f406d80c392e8fe1526821', 'width': 108, 'height': 216}, {'url': 'https://preview.redd.it/ewmxi3oh0qa61.jpg?width=216&crop=smart&auto=webp&s=8a17d90cc15dd23553ef242c745e4778433bb688', 'width': 216, 'height': 432}, {'url': 'https://preview.redd.it/ewmxi3oh0qa61.jpg?width=320&crop=smart&auto=webp&s=cf96d90f497ac4aa69e7406fb086acd617109796', 'width': 320, 'height': 640}, {'url': 'https://preview.redd.it/ewmxi3oh0qa61.jpg?width=640&crop=smart&auto=webp&s=9f244d11f6ec6ce3cadac808000986bdb65bde43', 'width': 640, 'height': 1280}], 'variants': {}, 'id': 'xCdxQcv2DWrdDZap3OJx6lq9-z5GVPP7yq01vYW_bd4'}], 'enabled': True}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kv4oca	True	None	Xfiles1987	None	131	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kv4oca/camp_auschwitz_guy_identified/	all_ads	False	https://i.redd.it/ewmxi3oh0qa61.jpg	175113	1.610378e+09	2	None	False	NaN	NaN	NaN	NaN
3	None	democrats	t2_yfff4	False	None	0	False	No Crawling Back!!!	[{'e': 'text', 't': '📄Effortpost'}]	r/democrats	False	6		129.0	None	False	t3_kvekkt	False	dark	0.98	None	public	378	1	{}	140.0	None	False	[]	None	True	False	None	{}	📄Effortpost	False	378	None	True	https://b.thumbs.redditmedia.com/9-aJH-bi1cSYsH3t_1SPCYfAWfYguWlTj4Cjd-uvuUw.jpg	False	None	[]	{}	image	None	False	None	NaN	1.610435e+09	richtext	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/863qmtjcbsa61.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/863qmtjcbsa61.jpg?auto=webp&s=ac402f4badd1004818c485fe399d7d69354e25cf', 'width': 828, 'height': 766}, 'resolutions': [{'url': 'https://preview.redd.it/863qmtjcbsa61.jpg?width=108&crop=smart&auto=webp&s=55bdc21ce13a3914183f74670edf5c1d30883d8c', 'width': 108, 'height': 99}, {'url': 'https://preview.redd.it/863qmtjcbsa61.jpg?width=216&crop=smart&auto=webp&s=7dcadb9051c71f6d263bb9d21a437c8f7d39d8ee', 'width': 216, 'height': 199}, {'url': 'https://preview.redd.it/863qmtjcbsa61.jpg?width=320&crop=smart&auto=webp&s=a328d2d4dad27fc5a7d283aaac65bdebcd20cf02', 'width': 320, 'height': 296}, {'url': 'https://preview.redd.it/863qmtjcbsa61.jpg?width=640&crop=smart&auto=webp&s=4a4d495523640c252bf1f6ae8fbf206cf6042b5e', 'width': 640, 'height': 592}], 'variants': {}, 'id': 'rRAa0tA4_4UmlEJtMgeSluCuOSq_xmHKtS08meyHSGM'}], 'enabled': True}	[{'giver_coin_reward': 0, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 20, 'id': 'award_abb865cf-620b-4219-8777-3658cf9091fb', 'penny_donate': 0, 'award_sub_type': 'PREMIUM', 'coin_reward': 0, 'icon_url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_512.png', 'days_of_premium': 0, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Starstruck_128.png', 'width': 128, 'height': 128}], 'icon_width': 512, 'static_icon_width': 512, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'Can't stop seeing stars', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 512, 'name': 'Starstruck', 'resized_static_icons': [{'url': 'https://preview.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png?width=16&height=16&auto=webp&s=800ea0775a3f25602bfab03058d64d25352c04d2', 'width': 16, 'height': 16}, {'url': 'https://preview.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png?width=32&height=32&auto=webp&s=1d4be9117f8e389c54e0a7e23918355d7d2df185', 'width': 32, 'height': 32}, {'url': 'https://preview.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png?width=48&height=48&auto=webp&s=45443e65acd1cf76585f7c9d904e1484f89db521', 'width': 48, 'height': 48}, {'url': 'https://preview.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png?width=64&height=64&auto=webp&s=f4164f96ab1df25de2024b8b65e9ce91d3424c86', 'width': 64, 'height': 64}, {'url': 'https://preview.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png?width=128&height=128&auto=webp&s=b09819f49e26e5ad518dbdf1aa69f0916d514c6e', 'width': 128, 'height': 128}], 'icon_format': 'APNG', 'icon_height': 512, 'penny_price': 0, 'award_type': 'global', 'static_icon_url': 'https://i.redd.it/award_images/t5_22cerq/snotiq9vxyn51_Starstruck.png'}]	[]	False	1a2d922c-dd58-11ea-812c-0e3b77e24cb9	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ffd635	kvekkt	True	None	Phatbrew	None	35	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvekkt/no_crawling_back/	all_ads	False	https://i.redd.it/863qmtjcbsa61.jpg	175113	1.610406e+09	0	None	False	NaN	NaN	NaN	NaN
4	None	democrats	t2_2tm5mq8b	False	None	0	False	Use the 14th Amendment to ban Trump	[{'e': 'text', 't': '🗳️ Beat Trump'}]	r/democrats	False	6		134.0	None	False	t3_kvfqwa	False	light	0.99	None	public	127	0	{}	140.0	None	False	[]	None	True	False	None	{}	🗳️ Beat Trump	False	127	None	False	https://b.thumbs.redditmedia.com/vwXKKbri_gr3sZc5k1BzCQBGPFkxbk6M81UHqf1CG9o.jpg	False	None	[]	{}	image	None	False	None	NaN	1.610439e+09	richtext	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/nil93j0cmsa61.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/nil93j0cmsa61.jpg?auto=webp&s=d7f3bb08c3632f30a0c0c1c05cdebf8b84c3dea1', 'width': 828, 'height': 797}, 'resolutions': [{'url': 'https://preview.redd.it/nil93j0cmsa61.jpg?width=108&crop=smart&auto=webp&s=e14a970ec34166d4be246fa2860e6da58901a38c', 'width': 108, 'height': 103}, {'url': 'https://preview.redd.it/nil93j0cmsa61.jpg?width=216&crop=smart&auto=webp&s=43db370d57b761f7a0a7234da803cd79eaae97d1', 'width': 216, 'height': 207}, {'url': 'https://preview.redd.it/nil93j0cmsa61.jpg?width=320&crop=smart&auto=webp&s=30df1a2a53d521438a48c989da487368f32e381d', 'width': 320, 'height': 308}, {'url': 'https://preview.redd.it/nil93j0cmsa61.jpg?width=640&crop=smart&auto=webp&s=e3a7c3e57c7c7de5a91563141833ec8bdac9bf52', 'width': 640, 'height': 616}], 'variants': {}, 'id': 'H1OOHVy0JeGp386PyJb49V1oDqt8KyRBvRhwI1AxIdc'}], 'enabled': True}	[]	[]	False	d5bbc84c-dd58-11ea-b388-0e8e81330acb	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ff0000	kvfqwa	True	None	UploadedMind	None	7	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvfqwa/use_the_14th_amendment_to_ban_trump/	all_ads	False	https://i.redd.it/nil93j0cmsa61.jpg	175113	1.610410e+09	0	None	False	NaN	NaN	NaN	NaN
5	None	democrats	t2_5tyafed5	False	None	1	False	Arguing with Republicans Over the Storming of the Capitol	[]	r/democrats	False	6	None	140.0	None	False	t3_kvg5ha	False	dark	0.99	None	public	114	2	{}	140.0	None	False	[]	None	True	False	None	{}	None	False	114	None	True	https://a.thumbs.redditmedia.com/tC_BS5MJ6l1O6JBYHiTlW81dN9pUV3WLO6-aCqIATW0.jpg	False	None	[]	{'gid_1': 1, 'gid_2': 1}	image	None	False	None	NaN	1.610440e+09	text	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/p7wykho8qsa61.png	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/p7wykho8qsa61.png?auto=webp&s=1eff17ceefcc48da5e452feef1238669cf0b4cd8', 'width': 1056, 'height': 1806}, 'resolutions': [{'url': 'https://preview.redd.it/p7wykho8qsa61.png?width=108&crop=smart&auto=webp&s=e8bb3722ace96312985c6898cb3fe120b2160ac2', 'width': 108, 'height': 184}, {'url': 'https://preview.redd.it/p7wykho8qsa61.png?width=216&crop=smart&auto=webp&s=ffc156532ecd0cf1eda9efae79f664515f2d4612', 'width': 216, 'height': 369}, {'url': 'https://preview.redd.it/p7wykho8qsa61.png?width=320&crop=smart&auto=webp&s=5adda34542527c1955a525528887cc0757a21065', 'width': 320, 'height': 547}, {'url': 'https://preview.redd.it/p7wykho8qsa61.png?width=640&crop=smart&auto=webp&s=322483598d6063bd9906eabd1e0947451d5384f6', 'width': 640, 'height': 1094}, {'url': 'https://preview.redd.it/p7wykho8qsa61.png?width=960&crop=smart&auto=webp&s=e84593742066d49ab04b66d0db9110c76ebfc1a4', 'width': 960, 'height': 1641}], 'variants': {}, 'id': 'zeBVM9Rvmct1vSuGoPZ0kcOFabU4B9i25QndRV4OphA'}], 'enabled': True}	[{'giver_coin_reward': None, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 500, 'id': 'gid_2', 'penny_donate': None, 'award_sub_type': 'GLOBAL', 'coin_reward': 100, 'icon_url': 'https://www.redditstatic.com/gold/awards/icon/gold_512.png', 'days_of_premium': 7, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/gold_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_128.png', 'width': 128, 'height': 128}], 'icon_width': 512, 'static_icon_width': 512, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'Gives 100 Reddit Coins and a week of r/lounge access and ad-free browsing.', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 512, 'name': 'Gold', 'resized_static_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/gold_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/gold_128.png', 'width': 128, 'height': 128}], 'icon_format': None, 'icon_height': 512, 'penny_price': None, 'award_type': 'global', 'static_icon_url': 'https://www.redditstatic.com/gold/awards/icon/gold_512.png'}, {'giver_coin_reward': None, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 100, 'id': 'gid_1', 'penny_donate': None, 'award_sub_type': 'GLOBAL', 'coin_reward': 0, 'icon_url': 'https://www.redditstatic.com/gold/awards/icon/silver_512.png', 'days_of_premium': 0, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/silver_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_128.png', 'width': 128, 'height': 128}], 'icon_width': 512, 'static_icon_width': 512, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'Shows the Silver Award... and that's it.', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 512, 'name': 'Silver', 'resized_static_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/silver_16.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_32.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_48.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_64.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/silver_128.png', 'width': 128, 'height': 128}], 'icon_format': None, 'icon_height': 512, 'penny_price': None, 'award_type': 'global', 'static_icon_url': 'https://www.redditstatic.com/gold/awards/icon/silver_512.png'}]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kvg5ha	True	None	NukeTheWhalesPoster	None	3	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvg5ha/arguing_with_republicans_over_the_storming_of_the/	all_ads	False	https://i.redd.it/p7wykho8qsa61.png	175113	1.610411e+09	0	None	False	NaN	NaN	NaN	NaN
6	None	democrats	t2_g5taa	False	None	0	False	‘There will be Trump Supporters who try to kill us,’ says Republican congressman on going against Trump	[]	r/democrats	False	6	None	92.0	None	False	t3_kvhzy8	False	dark	0.99	None	public	74	1	{}	140.0	None	False	[]	None	False	False	None	{}	None	False	74	None	False	https://b.thumbs.redditmedia.com/mayalW3x5MZN07DNTU9GhmNRhKY4iKkVgKH2f6pKgas.jpg	False	None	[]	{}	link	None	False	None	NaN	1.610446e+09	text	6	None	None	text	cnbc.com	True	None	None	None	None	https://www.cnbc.com/2021/01/11/people-will-try-to-kill-us-says-gop-lawmaker-on-going-against-trump.html?__source=iosappshare%7Ccom.apple.UIKit.activity.CopyToPasteboard	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?auto=webp&s=98cacc8551668b8083228fc28e44872d601f39dd', 'width': 3500, 'height': 2317}, 'resolutions': [{'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=108&crop=smart&auto=webp&s=6d0ea8f0c3708035db4ede4982cb5438421b82ab', 'width': 108, 'height': 71}, {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=216&crop=smart&auto=webp&s=45fa202f5ee44ce6dfcdff87a8852665b8657fd7', 'width': 216, 'height': 142}, {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=320&crop=smart&auto=webp&s=13f1adbbfdb78152227f9f90c183cfad8824d63a', 'width': 320, 'height': 211}, {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=640&crop=smart&auto=webp&s=a8dd4f379ddd6befb6379d1cfc026b33a23d89ea', 'width': 640, 'height': 423}, {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=960&crop=smart&auto=webp&s=038a735d4be6939d87d3760b18578bd192c25ad4', 'width': 960, 'height': 635}, {'url': 'https://external-preview.redd.it/rJiR5JJYFEHlOm0hHM03IXA8vfjegEGsO5YbPgZgykk.jpg?width=1080&crop=smart&auto=webp&s=ae9051722db86e86f5b0e5f2d46d21e0e074cdb0', 'width': 1080, 'height': 714}], 'variants': {}, 'id': 'aOvkpVf7Mhs_RwgRmxo06MOeDP3EGUKqh7JjqOrkVeM'}], 'enabled': False}	[{'giver_coin_reward': None, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 30, 'id': 'award_b4ff447e-05a5-42dc-9002-63568807cfe6', 'penny_donate': None, 'award_sub_type': 'PREMIUM', 'coin_reward': 0, 'icon_url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'days_of_premium': 0, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'width': 16, 'height': 16}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'width': 32, 'height': 32}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'width': 48, 'height': 48}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'width': 64, 'height': 64}, {'url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png', 'width': 128, 'height': 128}], 'icon_width': 2048, 'static_icon_width': 2048, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'A glowing commendation for all to see', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 2048, 'name': 'All-Seeing Upvote', 'resized_static_icons': [{'url': 'https://external-preview.redd.it?width=16&height=16&auto=webp&s=d88c9a453f8ac38850b7a8241cfe5804b7b4905d', 'width': 16, 'height': 16}, {'url': 'https://external-preview.redd.it?width=32&height=32&auto=webp&s=96a25019eb75878bdec4f6c012540f3baffbb1b2', 'width': 32, 'height': 32}, {'url': 'https://external-preview.redd.it?width=48&height=48&auto=webp&s=1a51d27d75afde3fbde8bba84f9338f511211461', 'width': 48, 'height': 48}, {'url': 'https://external-preview.redd.it?width=64&height=64&auto=webp&s=96af5ec460b05669ed60224cb0619bb8884abe27', 'width': 64, 'height': 64}, {'url': 'https://external-preview.redd.it?width=128&height=128&auto=webp&s=2d3e648ed2302e6258673051ca5291f57beb29d4', 'width': 128, 'height': 128}], 'icon_format': 'APNG', 'icon_height': 2048, 'penny_price': None, 'award_type': 'global', 'static_icon_url': 'https://www.redditstatic.com/gold/awards/icon/Illuminati_512.png'}]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kvhzy8	True	None	MBlaizze	None	16	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvhzy8/there_will_be_trump_supporters_who_try_to_kill_us/	all_ads	False	https://www.cnbc.com/2021/01/11/people-will-try-to-kill-us-says-gop-lawmaker-on-going-against-trump.html?__source=iosappshare%7Ccom.apple.UIKit.activity.CopyToPasteboard	175113	1.610418e+09	1	None	False	NaN	NaN	NaN	NaN
7	None	democrats	t2_8xm96m07	False	None	0	False	Patriots coach Bill Belichick turns down Presidential Medal of Freedom from Trump	[{'e': 'text', 't': '🗳️ Beat Trump'}]	r/democrats	False	6		105.0	None	False	t3_kvh5nr	False	light	0.95	None	public	57	0	{}	140.0	None	False	[]	None	False	False	None	{}	🗳️ Beat Trump	False	57	None	True	https://b.thumbs.redditmedia.com/vZMOrx8G21TrNUMujmOhFNCED4t4Igu-7fGX2_EfeOs.jpg	False	None	[]	{}	link	None	False	None	NaN	1.610444e+09	richtext	6	None	None	text	independent.co.uk	False	None	None	None	None	https://www.independent.co.uk/news/world/americas/us-politics/belichick-nfl-trump-medal-patriots-b1785781.html	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?auto=webp&s=d44652918ffa666eccbc2179584561fb847622cf', 'width': 2000, 'height': 1500}, 'resolutions': [{'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=108&crop=smart&auto=webp&s=917cdbd956dc256a3878fd7d7f62ec786d14ca3b', 'width': 108, 'height': 81}, {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=216&crop=smart&auto=webp&s=69cff5b7014370cd0163c5c5abda67923af7602a', 'width': 216, 'height': 162}, {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=320&crop=smart&auto=webp&s=5ea333beb3a65cda18caa325c5d416343dcd0a01', 'width': 320, 'height': 240}, {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=640&crop=smart&auto=webp&s=a3172880992a80c9a77897e42a6c1777b186b3bc', 'width': 640, 'height': 480}, {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=960&crop=smart&auto=webp&s=da53a18b5f74f77e43c80e52d2fb203db8a5fdf4', 'width': 960, 'height': 720}, {'url': 'https://external-preview.redd.it/bJNJ0QaSsjmrCEfeMuxV3gntb5NnJcuz4g__zct7MlU.jpg?width=1080&crop=smart&auto=webp&s=2b9fd7ea3c9ca9a09bfe9aeca47f447d739456f2', 'width': 1080, 'height': 810}], 'variants': {}, 'id': 'TEOA6DdC6M-8y0LHmTyEKza-0VlR-_SrTSNTwdHXslk'}], 'enabled': False}	[]	[]	False	d5bbc84c-dd58-11ea-b388-0e8e81330acb	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ff0000	kvh5nr	True	None	Wong_John	None	5	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvh5nr/patriots_coach_bill_belichick_turns_down/	all_ads	False	https://www.independent.co.uk/news/world/americas/us-politics/belichick-nfl-trump-medal-patriots-b1785781.html	175113	1.610415e+09	0	None	False	NaN	NaN	NaN	NaN
8	None	democrats	t2_8xm96m07	False	None	0	False	Most of the arrests from the Capitol riots have been misdemeanor curfew violations. This searchable table shows everyone charged so far.	[{'a': ':snoo:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/3whaar0s9ezz_t5_3nqvj/snoo'}, {'e': 'text', 't': ' Article '}]	r/democrats	False	6		70.0	None	False	t3_kvkgtt	False	light	0.94	None	public	27	0	{}	140.0	None	False	[]	None	False	False	None	{}	:snoo: Article	False	27	None	True	https://b.thumbs.redditmedia.com/fdtjqlHXaViCx8Ljd5yzT9SlC50vBsVOMp3sXVJSJso.jpg	False	None	[]	{}	link	None	False	None	NaN	1.610455e+09	richtext	6	None	None	text	insider.com	False	None	None	None	None	https://www.insider.com/all-the-us-capitol-pro-trump-riot-arrests-charges-names-2021-1	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?auto=webp&s=10aa0add28811a8c01083f3baa5b2c4799c67396', 'width': 1200, 'height': 600}, 'resolutions': [{'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=108&crop=smart&auto=webp&s=fe51472032a6c21679344b0da3512b74e180890d', 'width': 108, 'height': 54}, {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=216&crop=smart&auto=webp&s=41c7adaf1579e45ad32638ca0f168e55534f970e', 'width': 216, 'height': 108}, {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=320&crop=smart&auto=webp&s=7fbaa996365559ac6fe3666676587f3db04c571b', 'width': 320, 'height': 160}, {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=640&crop=smart&auto=webp&s=35c836b943d9b9765a87f954dbc117e48c96aa8e', 'width': 640, 'height': 320}, {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=960&crop=smart&auto=webp&s=dc14e730290be32d0f712e3207f4368baae371d2', 'width': 960, 'height': 480}, {'url': 'https://external-preview.redd.it/Dl9zHBfZtxjHf_Xs3hACJ98aq0yJyLaSrMHW2wc1OOw.jpg?width=1080&crop=smart&auto=webp&s=0548f957d518c3616a6abab8f5e67d5178b42314', 'width': 1080, 'height': 540}], 'variants': {}, 'id': 'W7tWF3uZ9KoDFc25Z9kgN4a2bxaj4_aSkYmc4gFX0jk'}], 'enabled': False}	[]	[]	False	ec699eba-dd59-11ea-8dc8-0ecbe56cff1d	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#5f9dd2	kvkgtt	True	None	Wong_John	None	1	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvkgtt/most_of_the_arrests_from_the_capitol_riots_have/	all_ads	False	https://www.insider.com/all-the-us-capitol-pro-trump-riot-arrests-charges-names-2021-1	175113	1.610426e+09	0	None	False	NaN	NaN	NaN	NaN
9	None	democrats	t2_1zz5jz17	False	None	0	False	QAnon congresswoman who live-tweeted Nancy Pelosi's location to rioters now facing calls for arrest	[]	r/democrats	False	6	None	94.0	None	False	t3_kvfbhb	False	dark	0.97	None	public	61	0	{}	140.0	None	False	[]	None	False	False	None	{}	None	False	61	None	False	https://b.thumbs.redditmedia.com/5qbRN2HaMj5RT6ukxM9clssKu7dN2wQCyHhFzV5buLo.jpg	False	None	[]	{}	link	None	False	None	NaN	1.610437e+09	text	6	None	None	text	salon.com	False	None	None	None	None	https://www.salon.com/2021/01/11/qanon-congresswoman-who-live-tweeted-nancy-pelosis-location-to-rioters-now-facing-calls-for-arrest_partner/	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/kHX3837Vw4HSbuj3pPk4eHSvTxsB4sePvmt00DnziK0.jpg?auto=webp&s=d6784306451f948469f3c5eeb955246cb431a2fc', 'width': 846, 'height': 571}, 'resolutions': [{'url': 'https://external-preview.redd.it/kHX3837Vw4HSbuj3pPk4eHSvTxsB4sePvmt00DnziK0.jpg?width=108&crop=smart&auto=webp&s=c925a143a66cb8f9b2ae1df7c320e8eb4923b2db', 'width': 108, 'height': 72}, {'url': 'https://external-preview.redd.it/kHX3837Vw4HSbuj3pPk4eHSvTxsB4sePvmt00DnziK0.jpg?width=216&crop=smart&auto=webp&s=b01dcd60579fa66b3cf6c35c647661dab3bc4870', 'width': 216, 'height': 145}, {'url': 'https://external-preview.redd.it/kHX3837Vw4HSbuj3pPk4eHSvTxsB4sePvmt00DnziK0.jpg?width=320&crop=smart&auto=webp&s=ea4d8e780b763f23883b064ddacde1597b57703f', 'width': 320, 'height': 215}, {'url': 'https://external-preview.redd.it/kHX3837Vw4HSbuj3pPk4eHSvTxsB4sePvmt00DnziK0.jpg?width=640&crop=smart&auto=webp&s=0fadbd393d31eca693afe6d64097e9f9d6f6f686', 'width': 640, 'height': 431}], 'variants': {}, 'id': 'bzEoykUuO90QpXY0pCEjVDM51pVU2WzVFLwcEzbfL9E'}], 'enabled': False}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kvfbhb	True	None	dakandy	None	14	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kvfbhb/qanon_congresswoman_who_livetweeted_nancy_pelosis/	all_ads	False	https://www.salon.com/2021/01/11/qanon-congresswoman-who-live-tweeted-nancy-pelosis-location-to-rioters-now-facing-calls-for-arrest_partner/	175113	1.610409e+09	0	None	False	NaN	NaN	NaN	NaN

Last rows

	approved_at_utc	subreddit	selftext	author_fullname	saved	mod_reason_title	clicked	title	link_flair_richtext	subreddit_name_prefixed	hidden	pwls	link_flair_css_class	thumbnail_height	top_awarded_type	hide_score	name	quarantine	link_flair_text_color	upvote_ratio	author_flair_background_color	subreddit_type	ups	total_awards_received	media_embed	thumbnail_width	author_flair_template_id	is_original_content	user_reports	secure_media	is_reddit_media_domain	is_meta	category	secure_media_embed	link_flair_text	can_mod_post	score	approved_by	author_premium	thumbnail	edited	author_flair_css_class	author_flair_richtext	gildings	post_hint	content_categories	is_self	mod_note	crosspost_parent_list	created	link_flair_type	wls	removed_by_category	banned_by	author_flair_type	domain	allow_live_comments	selftext_html	likes	suggested_sort	banned_at_utc	url_overridden_by_dest	view_count	archived	no_follow	is_crosspostable	pinned	over_18	preview	all_awardings	awarders	media_only	link_flair_template_id	can_gild	spoiler	locked	author_flair_text	treatment_tags	visited	removed_by	num_reports	distinguished	subreddit_id	mod_reason_by	removal_reason	link_flair_background_color	id	is_robot_indexable	report_reasons	author	discussion_type	num_comments	send_replies	whitelist_status	contest_mode	mod_reports	author_patreon_flair	crosspost_parent	author_flair_text_color	permalink	parent_whitelist_status	stickied	url	subreddit_subscribers	created_utc	media	is_video	author_cakeday	is_gallery	media_metadata	gallery_data
980	None	democrats		t2_85afk8ls	False	None	False	It’s nice having a realistic President!	[{'a': ':snoo_feelsgoodman:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/nbv1idzmaezz_t5_3nqvj/snoo_feelsgoodman'}, {'e': 'text', 't': ' Discussion '}, {'a': ':snoo_thoughtful:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/7jhvwsc5aezz_t5_3nqvj/snoo_thoughtful'}]	r/democrats	False	6		50.0	None	False	t3_kqak2i	False	light	0.85	None	public	18	0	{}	140.0	None	False	[]	None	True	False	None	{}	:snoo_feelsgoodman: Discussion :snoo_thoughtful:	False	18	None	False	https://a.thumbs.redditmedia.com/dB6Mc1kMGPNvVsRvMjxVEeOlker4lw6WW4y-sp0oOh0.jpg	False	None	[]	{}	image	None	False	None	NaN	1.609802e+09	richtext	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/0fzwenoc0c961.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/0fzwenoc0c961.jpg?auto=webp&s=f335b28906ad1fb3ccd5931da22e1728fa5ef48b', 'width': 750, 'height': 271}, 'resolutions': [{'url': 'https://preview.redd.it/0fzwenoc0c961.jpg?width=108&crop=smart&auto=webp&s=88ec5c1bda26ca88d19dba664d47c881873e4e44', 'width': 108, 'height': 39}, {'url': 'https://preview.redd.it/0fzwenoc0c961.jpg?width=216&crop=smart&auto=webp&s=84f29da58d0dcb64a00bf0d36b3d66b61c226d72', 'width': 216, 'height': 78}, {'url': 'https://preview.redd.it/0fzwenoc0c961.jpg?width=320&crop=smart&auto=webp&s=b2841f09e5eec84336e6c17473f2df5576ff5932', 'width': 320, 'height': 115}, {'url': 'https://preview.redd.it/0fzwenoc0c961.jpg?width=640&crop=smart&auto=webp&s=7a90ecf723ea33175c30a685783442207fb6aff1', 'width': 640, 'height': 231}], 'variants': {}, 'id': 'mqQ-bq2JyR-uHEnqk8KlOjNTAFhdnHC8tmPZ-3W9GJU'}], 'enabled': True}	[]	[]	False	0bf3b48c-dd5a-11ea-891c-0eb295b8865f	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ff4500	kqak2i	True	None	survivspicymilk	None	1	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqak2i/its_nice_having_a_realistic_president/	all_ads	False	https://i.redd.it/0fzwenoc0c961.jpg	175116	1.609773e+09	None	False	NaN	NaN	NaN	NaN
981	None	democrats		t2_5ssugamc	False	None	False	No title needed	[{'a': ':snoo_joy:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/ehw8l3piaezz_t5_3nqvj/snoo_joy'}, {'e': 'text', 't': ' Meme'}]	r/democrats	False	6		107.0	None	False	t3_kqd59p	False	light	0.82	None	public	10	0	{}	140.0	None	False	[]	None	True	False	None	{}	:snoo_joy: Meme	False	10	None	False	https://b.thumbs.redditmedia.com/moDzfty-KIcGjBPsi2T1dH0yw2WYj0RooibOP3WeQSw.jpg	False	None	[]	{}	image	None	False	None	NaN	1.609810e+09	richtext	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/wutsq1ncnc961.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?auto=webp&s=0fda04ed796c2ef54d2e3dcbddafed9bbf17b8d0', 'width': 1200, 'height': 923}, 'resolutions': [{'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=108&crop=smart&auto=webp&s=ea28959b24dd1ee49e05e071eed1e7782c4ec7da', 'width': 108, 'height': 83}, {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=216&crop=smart&auto=webp&s=6f57de27250d9f4f0281a846faf937c2d10cd8ed', 'width': 216, 'height': 166}, {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=320&crop=smart&auto=webp&s=e80eca2eaec7a8a5a3e7d29c265b797035f1a9b8', 'width': 320, 'height': 246}, {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=640&crop=smart&auto=webp&s=cd4ed45c354a0ca7e0bc84ed3b8a21f910088466', 'width': 640, 'height': 492}, {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=960&crop=smart&auto=webp&s=ba44864f76808584b8376ab432d681c9cd59bc9d', 'width': 960, 'height': 738}, {'url': 'https://preview.redd.it/wutsq1ncnc961.jpg?width=1080&crop=smart&auto=webp&s=bfd941ddb5bde9d4784ace1366bfa4259f74160b', 'width': 1080, 'height': 830}], 'variants': {}, 'id': 'LwtJk4oDmtmR0JQ1WDr9iqDgKnW_GX33gPaZ8NeBfII'}], 'enabled': True}	[]	[]	False	fc8afa6e-dd59-11ea-8541-0e09e4b7c31f	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#349e48	kqd59p	True	None	RecordEnvironmental4	None	0	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqd59p/no_title_needed/	all_ads	False	https://i.redd.it/wutsq1ncnc961.jpg	175116	1.609781e+09	None	False	NaN	NaN	NaN	NaN
982	None	democrats		t2_6n9zacfv	False	None	False	He's got a point!	[]	r/democrats	False	6	None	140.0	None	False	t3_kq64b0	False	dark	0.94	None	public	40	0	{}	140.0	None	False	[]	None	True	False	None	{}	None	False	40	None	False	https://b.thumbs.redditmedia.com/uzE5ZWub9rp1m1xXCrl1UAGa8AW4X8xvZmV_Yxcxqhw.jpg	False	None	[]	{}	image	None	False	None	NaN	1.609785e+09	text	6	None	None	text	i.redd.it	False	None	None	None	None	https://i.redd.it/gah4wwcila961.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://preview.redd.it/gah4wwcila961.jpg?auto=webp&s=20b1f64ddd8a3234aba60e609c651f94ed5f9ef1', 'width': 1010, 'height': 1130}, 'resolutions': [{'url': 'https://preview.redd.it/gah4wwcila961.jpg?width=108&crop=smart&auto=webp&s=b5715f866f0fa3d27ec074f8c27827caeb4f2e54', 'width': 108, 'height': 120}, {'url': 'https://preview.redd.it/gah4wwcila961.jpg?width=216&crop=smart&auto=webp&s=d0f258a95c249828ffb8787167d83f04cec74dbb', 'width': 216, 'height': 241}, {'url': 'https://preview.redd.it/gah4wwcila961.jpg?width=320&crop=smart&auto=webp&s=faa0dbc47152fa3fab85c4f8dc6796a4c2c28352', 'width': 320, 'height': 358}, {'url': 'https://preview.redd.it/gah4wwcila961.jpg?width=640&crop=smart&auto=webp&s=cbab2ccbe09c8f82fabed16656e1e51ca2e30fd8', 'width': 640, 'height': 716}, {'url': 'https://preview.redd.it/gah4wwcila961.jpg?width=960&crop=smart&auto=webp&s=ca9f052c4df18a54e4a66359a35b16e889bcd8f9', 'width': 960, 'height': 1074}], 'variants': {}, 'id': 'VQpE79MiNrmQ9i1h8jGYGT1Jl33S060Ll5szKy98dYI'}], 'enabled': True}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kq64b0	True	None	letstalkaboutit24	None	4	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kq64b0/hes_got_a_point/	all_ads	False	https://i.redd.it/gah4wwcila961.jpg	175116	1.609756e+09	None	False	NaN	NaN	NaN	NaN
983	None	democrats		t2_vem9pyr	False	None	False	There are limited number of tickets to the Trump March on Jan 6. Be sure to sign up now and NOT go!	[]	r/democrats	False	6	None	NaN	None	False	t3_kq15pj	False	dark	0.90	None	public	91	1	{}	NaN	None	False	[]	None	False	False	None	{}	None	False	91	None	False	default	False	None	[]	{}	NaN	None	False	None	NaN	1.609763e+09	text	6	None	None	text	trumpmarch.com	False	None	None	None	None	https://trumpmarch.com	None	False	False	False	False	False	NaN	[{'giver_coin_reward': 0, 'subreddit_id': None, 'is_new': False, 'days_of_drip_extension': 0, 'coin_price': 80, 'id': 'award_8352bdff-3e03-4189-8a08-82501dd8f835', 'penny_donate': 0, 'award_sub_type': 'GLOBAL', 'coin_reward': 0, 'icon_url': 'https://i.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png', 'days_of_premium': 0, 'tiers_by_required_awardings': None, 'resized_icons': [{'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=16&height=16&auto=webp&s=69997ace3ef4ffc099b81d774c2c8f1530602875', 'width': 16, 'height': 16}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=32&height=32&auto=webp&s=e9519d1999ef9dce5c8a9f59369cb92f52d95319', 'width': 32, 'height': 32}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=48&height=48&auto=webp&s=f076c6434fb2d2f9075991810fd845c40fa73fc6', 'width': 48, 'height': 48}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=64&height=64&auto=webp&s=85527145e0c4b754306a30df29e584fd16187636', 'width': 64, 'height': 64}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=128&height=128&auto=webp&s=b8843cdf82c3b741d7af057c14076dcd2621e811', 'width': 128, 'height': 128}], 'icon_width': 2048, 'static_icon_width': 2048, 'start_date': None, 'is_enabled': True, 'awardings_required_to_grant_benefits': None, 'description': 'Everything is better with a good hug', 'end_date': None, 'subreddit_coin_reward': 0, 'count': 1, 'static_icon_height': 2048, 'name': 'Hugz', 'resized_static_icons': [{'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=16&height=16&auto=webp&s=69997ace3ef4ffc099b81d774c2c8f1530602875', 'width': 16, 'height': 16}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=32&height=32&auto=webp&s=e9519d1999ef9dce5c8a9f59369cb92f52d95319', 'width': 32, 'height': 32}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=48&height=48&auto=webp&s=f076c6434fb2d2f9075991810fd845c40fa73fc6', 'width': 48, 'height': 48}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=64&height=64&auto=webp&s=85527145e0c4b754306a30df29e584fd16187636', 'width': 64, 'height': 64}, {'url': 'https://preview.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png?width=128&height=128&auto=webp&s=b8843cdf82c3b741d7af057c14076dcd2621e811', 'width': 128, 'height': 128}], 'icon_format': 'PNG', 'icon_height': 2048, 'penny_price': 0, 'award_type': 'global', 'static_icon_url': 'https://i.redd.it/award_images/t5_q0gj4/fpm0r5ryq1361_PolarHugs.png'}]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kq15pj	True	None	middle-name-is-sassy	None	22	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kq15pj/there_are_limited_number_of_tickets_to_the_trump/	all_ads	False	https://trumpmarch.com	175116	1.609734e+09	None	False	NaN	NaN	NaN	NaN
984	None	democrats	Like what the FUCK does that even mean?	t2_81ky4sgm	False	None	False	In YouTube comment sections I always hear people complaining about how the media isn't transparent when it comes to posting stories.	[{'e': 'text', 't': 'Question '}, {'a': ':snoo_thoughtful:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/7jhvwsc5aezz_t5_3nqvj/snoo_thoughtful'}]	r/democrats	False	6		NaN	None	False	t3_kqe5j1	False	light	0.78	None	public	8	0	{}	NaN	None	False	[]	None	False	False	None	{}	Question :snoo_thoughtful:	False	8	None	False	self	False	None	[]	{}	NaN	None	True	None	NaN	1.609813e+09	richtext	6	None	None	text	self.democrats	False	<!-- SC_OFF --><div class="md"><p>Like what the FUCK does that even mean?</p>\n</div><!-- SC_ON -->	None	None	None	NaN	None	False	False	False	False	False	NaN	[]	[]	False	366aed66-dd5a-11ea-84d2-0e5d79fe92b3	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#0079d3	kqe5j1	True	None	Emergency-Layer8132	None	5	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqe5j1/in_youtube_comment_sections_i_always_hear_people/	all_ads	False	https://www.reddit.com/r/democrats/comments/kqe5j1/in_youtube_comment_sections_i_always_hear_people/	175116	1.609784e+09	None	False	NaN	NaN	NaN	NaN
985	None	democrats		t2_4e7f3195	False	None	False	Georgia Democratic lawmaker to seek censure of Trump over Raffensperger call	[{'e': 'text', 't': 'article'}]	r/democrats	False	6	blue	85.0	None	False	t3_kq70fh	False	dark	0.89	None	public	22	0	{}	140.0	None	False	[]	None	False	False	None	{}	article	False	22	None	False	https://b.thumbs.redditmedia.com/cr9HxEU0fF5RZP098X7t7KsjFHWlp5NbK6vYezUshVY.jpg	False	None	[]	{}	link	None	False	None	NaN	1.609789e+09	richtext	6	None	None	text	thehill.com	False	None	None	None	None	https://thehill.com/homenews/house/532454-georgia-dem-lawmaker-to-seek-censure-of-trump-over-raffensperger-call	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?auto=webp&s=abaaec2bad5fe7dc7947e0902ced112bad85496a', 'width': 1440, 'height': 880}, 'resolutions': [{'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=108&crop=smart&auto=webp&s=7f7d5b04aae0c2f9c64e0744c0e33b55b7b5969f', 'width': 108, 'height': 66}, {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=216&crop=smart&auto=webp&s=1da1f888216794fea600c5ba3c1277f0b2e774c5', 'width': 216, 'height': 132}, {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=320&crop=smart&auto=webp&s=2cc87ebac0e9259c61215c3eafd65a9e9c401237', 'width': 320, 'height': 195}, {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=640&crop=smart&auto=webp&s=83d5a56e61cc9bab8eee769a251d16c980f2021f', 'width': 640, 'height': 391}, {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=960&crop=smart&auto=webp&s=6faac018898a9fbf610967e106f9a10d9446684c', 'width': 960, 'height': 586}, {'url': 'https://external-preview.redd.it/MwRVYBNFFk8pFI6e5S2JY_wP3FHcXxyWNnuVd7u05Jw.jpg?width=1080&crop=smart&auto=webp&s=3fb46cb6071668ac7eb62792bdb3480b4b926d98', 'width': 1080, 'height': 660}], 'variants': {}, 'id': 'NGnG-9PB9OQcGKa1MpKRm8ywatxy2iRluyEbjP4xets'}], 'enabled': False}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kq70fh	True	None	newsspotter	None	0	False	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kq70fh/georgia_democratic_lawmaker_to_seek_censure_of/	all_ads	False	https://thehill.com/homenews/house/532454-georgia-dem-lawmaker-to-seek-censure-of-trump-over-raffensperger-call	175116	1.609760e+09	None	False	NaN	NaN	NaN	NaN
986	None	democrats		t2_ievyh	False	None	False	Trump rewarding allies Nunes, Jordan with Medal of Freedom	[{'e': 'text', 't': 'article'}]	r/democrats	False	6	blue	96.0	None	False	t3_kqav45	False	dark	0.82	None	public	11	0	{}	140.0	None	False	[]	None	False	False	None	{}	article	False	11	None	False	https://b.thumbs.redditmedia.com/jesik5giTT7IMfuM5yoq89RqEmhtw8Gmkx5Igx_ER0s.jpg	False	None	[]	{}	link	None	False	None	NaN	1.609803e+09	richtext	6	None	None	text	apnews.com	False	None	None	None	None	https://apnews.com/article/election-2020-donald-trump-jim-jordan-elections-impeachments-e4bb09f9b35fddfaafa6efaf18e81dc9	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?auto=webp&s=b02f5c17fdd81e94bdafdedb56b04875ea9c2e99', 'width': 3000, 'height': 2067}, 'resolutions': [{'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=108&crop=smart&auto=webp&s=04c42967063988121377527000c765f170106dd6', 'width': 108, 'height': 74}, {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=216&crop=smart&auto=webp&s=d4ff0d1a95bb7ec60c51388d19642c17ae2fe014', 'width': 216, 'height': 148}, {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=320&crop=smart&auto=webp&s=ad867b6ccc33a49eb2c2ec081bd900e081ca3362', 'width': 320, 'height': 220}, {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=640&crop=smart&auto=webp&s=2883e676d59e465b8de25bf3c06f3e68ddb99456', 'width': 640, 'height': 440}, {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=960&crop=smart&auto=webp&s=103a353ee7cdb701c35c34e3eb2ed26a81ede2b4', 'width': 960, 'height': 661}, {'url': 'https://external-preview.redd.it/shE4e3qgYdTq4-lNDfNDnnEeFTvm_F90w5yxa_xxJz8.jpg?width=1080&crop=smart&auto=webp&s=45b832bba84ff3eea0b82e832277ffc4de2c49da', 'width': 1080, 'height': 744}], 'variants': {}, 'id': '-p1b992g6eP3qoVKm8g0vWL5ZNNE-wl-72vO7S6VoeY'}], 'enabled': False}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kqav45	True	None	suddenimpulse	None	5	False	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqav45/trump_rewarding_allies_nunes_jordan_with_medal_of/	all_ads	False	https://apnews.com/article/election-2020-donald-trump-jim-jordan-elections-impeachments-e4bb09f9b35fddfaafa6efaf18e81dc9	175116	1.609774e+09	None	False	NaN	NaN	NaN	NaN
987	None	democrats		t2_4kei3gto	False	None	False	Biden ALREADY More Popular Than Trump's Ever Been	[{'e': 'text', 't': '🗳️ Beat Trump'}]	r/democrats	False	6		105.0	None	False	t3_kqcz0s	False	light	0.79	None	public	8	0	{'content': '<iframe width="356" height="200" src="https://www.youtube.com/embed/rGms-hYz3DM?feature=oembed&enablejsapi=1" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>', 'width': 356, 'scrolling': False, 'height': 200}	140.0	None	False	[]	{'type': 'youtube.com', 'oembed': {'provider_url': 'https://www.youtube.com/', 'version': '1.0', 'title': 'Biden ALREADY More Popular Than Trump's Ever Been', 'type': 'video', 'thumbnail_width': 480, 'height': 200, 'width': 356, 'html': '<iframe width="356" height="200" src="https://www.youtube.com/embed/rGms-hYz3DM?feature=oembed&enablejsapi=1" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>', 'author_name': 'David Pakman Show', 'provider_name': 'YouTube', 'thumbnail_url': 'https://i.ytimg.com/vi/rGms-hYz3DM/hqdefault.jpg', 'thumbnail_height': 360, 'author_url': 'https://www.youtube.com/c/thedavidpakmanshow'}}	False	False	None	{'content': '<iframe width="356" height="200" src="https://www.youtube.com/embed/rGms-hYz3DM?feature=oembed&enablejsapi=1" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>', 'width': 356, 'scrolling': False, 'media_domain_url': 'https://www.redditmedia.com/mediaembed/kqcz0s', 'height': 200}	🗳️ Beat Trump	False	8	None	False	https://a.thumbs.redditmedia.com/zHokC0IZBth4ixXZinyKsje9jAYbtRYm9-g39UDZW28.jpg	False	None	[]	{}	rich:video	None	False	None	NaN	1.609809e+09	richtext	6	None	None	text	youtu.be	False	None	None	None	None	https://youtu.be/rGms-hYz3DM	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/bRxz1-REbq39qJ9wwXvK7boDvi1AnVeK0U1yDwFXV2I.jpg?auto=webp&s=d148b38d3b24e78d81fe14e2af52d487053fd6f8', 'width': 480, 'height': 360}, 'resolutions': [{'url': 'https://external-preview.redd.it/bRxz1-REbq39qJ9wwXvK7boDvi1AnVeK0U1yDwFXV2I.jpg?width=108&crop=smart&auto=webp&s=d2016b91c69f636a53e210f4a81a73d91280afe4', 'width': 108, 'height': 81}, {'url': 'https://external-preview.redd.it/bRxz1-REbq39qJ9wwXvK7boDvi1AnVeK0U1yDwFXV2I.jpg?width=216&crop=smart&auto=webp&s=231dbeccf914179bcc710802d17a89ba2f90bac3', 'width': 216, 'height': 162}, {'url': 'https://external-preview.redd.it/bRxz1-REbq39qJ9wwXvK7boDvi1AnVeK0U1yDwFXV2I.jpg?width=320&crop=smart&auto=webp&s=5716fe94fd7c43da1bac2eea96e68eb7ebb5fea3', 'width': 320, 'height': 240}], 'variants': {}, 'id': 'galI8u-5qELswEYFiDatFkvi06yGs8VSfBMi_lW4UKs'}], 'enabled': False}	[]	[]	False	d5bbc84c-dd58-11ea-b388-0e8e81330acb	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ff0000	kqcz0s	True	None	CautiousProcess	None	1	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqcz0s/biden_already_more_popular_than_trumps_ever_been/	all_ads	False	https://youtu.be/rGms-hYz3DM	175116	1.609780e+09	{'type': 'youtube.com', 'oembed': {'provider_url': 'https://www.youtube.com/', 'version': '1.0', 'title': 'Biden ALREADY More Popular Than Trump's Ever Been', 'type': 'video', 'thumbnail_width': 480, 'height': 200, 'width': 356, 'html': '<iframe width="356" height="200" src="https://www.youtube.com/embed/rGms-hYz3DM?feature=oembed&enablejsapi=1" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>', 'author_name': 'David Pakman Show', 'provider_name': 'YouTube', 'thumbnail_url': 'https://i.ytimg.com/vi/rGms-hYz3DM/hqdefault.jpg', 'thumbnail_height': 360, 'author_url': 'https://www.youtube.com/c/thedavidpakmanshow'}}	False	NaN	NaN	NaN	NaN
988	None	democrats		t2_612zd	False	None	False	Election Day Voting in 2020 Took Longer in America’s Poorest Neighborhoods	[{'e': 'text', 't': 'article'}]	r/democrats	False	6	blue	73.0	None	False	t3_kqd5xf	False	dark	0.82	None	public	7	0	{}	140.0	None	False	[]	None	False	False	None	{}	article	False	7	None	True	https://b.thumbs.redditmedia.com/L1HJt2rIspR4n7peXnDcKxzlEuJMvShzG_-5Egq4wWw.jpg	False	None	[]	{}	link	None	False	None	NaN	1.609810e+09	richtext	6	None	None	text	nytimes.com	False	None	None	None	None	https://www.nytimes.com/interactive/2021/01/04/upshot/voting-wait-times.html?action=click&module=Top%20Stories&pgtype=Homepage	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?auto=webp&s=a0162f429ec41749b5508ce879034271ae2603ab', 'width': 1050, 'height': 550}, 'resolutions': [{'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?width=108&crop=smart&auto=webp&s=c3f60f1f8cf3394b77635b2371c180ff57f2e04e', 'width': 108, 'height': 56}, {'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?width=216&crop=smart&auto=webp&s=c493fe62908adad752408e031e5ce84bd05e96e3', 'width': 216, 'height': 113}, {'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?width=320&crop=smart&auto=webp&s=8b71e02fb1393cbf8375eaf8fa26a7bbce55c2dd', 'width': 320, 'height': 167}, {'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?width=640&crop=smart&auto=webp&s=11b0b4580dbcb0acbea09322c2a2e5644387c314', 'width': 640, 'height': 335}, {'url': 'https://external-preview.redd.it/9cNx1tAmJrkSsZNgG5KncHiFoDWwH-Bn-a5orx1LJic.jpg?width=960&crop=smart&auto=webp&s=51bed5680b2cd6df8acbf8b0f874e83575191012', 'width': 960, 'height': 502}], 'variants': {}, 'id': 'qUbbm4PoQAkKNqGc80oS6fXAwwdvtnO_ecF7C-wMpNw'}], 'enabled': False}	[]	[]	False	NaN	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None		kqd5xf	True	None	DoremusJessup	None	1	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kqd5xf/election_day_voting_in_2020_took_longer_in/	all_ads	False	https://www.nytimes.com/interactive/2021/01/04/upshot/voting-wait-times.html?action=click&module=Top%20Stories&pgtype=Homepage	175116	1.609781e+09	None	False	NaN	NaN	NaN	NaN
989	None	democrats		t2_8jzrkmw2	False	None	False	Skid Mark President	[{'a': ':snoo_smile:', 'e': 'emoji', 'u': 'https://emoji.redditmedia.com/fh0615maaezz_t5_3nqvj/snoo_smile'}, {'e': 'text', 't': ' Satire'}]	r/democrats	False	6		140.0	None	False	t3_kq78j1	False	dark	0.79	None	public	13	0	{}	140.0	None	False	[]	None	False	False	None	{}	:snoo_smile: Satire	False	13	None	False	https://b.thumbs.redditmedia.com/ZoOtfPMCmoxGU6eci8E8UJTxcdA5YMSiIlmxb1FZmyQ.jpg	False	None	[]	{}	image	None	False	None	NaN	1.609790e+09	richtext	6	None	None	text	i.imgur.com	False	None	None	None	None	https://i.imgur.com/f2HS1UB.jpg	None	False	False	False	False	False	{'images': [{'source': {'url': 'https://external-preview.redd.it/jkof9ljaLfZv3lZUs1MsLGIwlmH74hjVmdz3kMVyjNs.jpg?auto=webp&s=cefaf5acdd5bfccd0bd60dc81221454d24c3938a', 'width': 669, 'height': 821}, 'resolutions': [{'url': 'https://external-preview.redd.it/jkof9ljaLfZv3lZUs1MsLGIwlmH74hjVmdz3kMVyjNs.jpg?width=108&crop=smart&auto=webp&s=2ecb39fde19070e0379db931c8393650ac8d8ede', 'width': 108, 'height': 132}, {'url': 'https://external-preview.redd.it/jkof9ljaLfZv3lZUs1MsLGIwlmH74hjVmdz3kMVyjNs.jpg?width=216&crop=smart&auto=webp&s=2315d2c454dd8960c732e631a36a925a90cc5cb8', 'width': 216, 'height': 265}, {'url': 'https://external-preview.redd.it/jkof9ljaLfZv3lZUs1MsLGIwlmH74hjVmdz3kMVyjNs.jpg?width=320&crop=smart&auto=webp&s=8d7c4b8be6e39ad06290e268d2055c4c53446471', 'width': 320, 'height': 392}, {'url': 'https://external-preview.redd.it/jkof9ljaLfZv3lZUs1MsLGIwlmH74hjVmdz3kMVyjNs.jpg?width=640&crop=smart&auto=webp&s=e62f541e1bef28a229bb82a4a43530f02150c42e', 'width': 640, 'height': 785}], 'variants': {}, 'id': 'Uz0SLbwfxNzD3mUrjMhc6qGt0vbUtrU0RYzKaBwmVEQ'}], 'enabled': True}	[]	[]	False	2fd2a1b2-dd58-11ea-be1a-0e61f7f81e33	False	False	False	None	[]	False	None	None	None	t5_2qn70	None	None	#ffb000	kq78j1	True	None	CynicalRealist1	None	0	True	all_ads	False	[]	False	NaN	None	/r/democrats/comments/kq78j1/skid_mark_president/	all_ads	False	https://i.imgur.com/f2HS1UB.jpg	175116	1.609761e+09	None	False	NaN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters